is designed to aggregate only numeric values. If you take the data as strings (with some letters in them) and set it as AggregateDescription, RadPivotGrid
is unable to do its job.
For your case - you can use Number format for your aggregated data, but it will be used for all of the items:
Based on your description I think you can use RadGridView
and receive the needed results. More information about RadGridView
features can be found in our online help
and in our online demos
the Telerik team