the data i'm aggregating contains a string value (eg. country) for each item.
I want to display the string value in the PivotGrid as followed:
There should be a column "Country" and the grouped items should display an empty string (since i see no good way to aggregate strings except maybe concatenating). When i open up the groups and drill down to a specific item, the "Country" column should display the country value for the item.
Is there any way to achive this?