You could hide the Grand Total row by setting the value of the RowGrandTotalsPosition
properties of the RadPivotGrid to None
. In order to achieve "grouping on Sum" you need to create custom AggregateFunction where you should sum all incoming money amounts. If you like to display custom group description like "Product Name" + "Currency", you could create a custom PropertyGroupDescription
and to override the GroupNameFromItem
method where you should return the custom description.
I've prepared and attached a sample project which demonstrates this approach. Please take a look and if you have any further questions, don't hesitate to contact us again.
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>