This is a migrated thread and some comments may be shown as answers.

Using different column header instead of Grand Total

1 Answer 226 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Asuman
Top achievements
Rank 1
Asuman asked on 03 Mar 2016, 07:02 PM

Hi Telerik Team,

RadPivotGrid control shows aggregate property names as column headers if we have more than one aggregate properties. But, it shows "Grand Total" phrase as column header if we have just one aggregate property.

I have two questions:

1- Is there any possibility for radpivotgrid control to show aggregate property name instead of "Grand Total" phrase if it has even just one aggregate property?

2- Is there any possibility to show simple aggregate property names as column headers without "Sum of" prefix?

 

Best regards...

1 Answer, 1 is accepted

Sort by
0
Polya
Telerik team
answered on 07 Mar 2016, 03:31 PM
Hello Asuman,

Let me get straight into answering the questions:
1- Is there any possibility for radpivotgrid control to show aggregate property name instead of "Grand Total" phrase if it has even just one aggregate property?
With the current implementation of RadPivotGrid the only way to change the text for "Grand Total" is with custom LocalizationManager. You can see the built in Localization in action in the following demo from our Silverlight examples:
http://demos.telerik.com/silverlight/#PivotGrid/Localization
For full list of the localization strings you can check the Localization article from the PivotGrid documentation and for how to apply custom LocalizationManager check this article.

2- Is there any possibility to show simple aggregate property names as column headers without "Sum of" prefix?
I suggest setting the PropertyAggregateDescription.CustomName property for your aggregate descriptions to a suitable string. In this case we will use only the CustomName and the FunctionName will not be taken into account. For example, if we set the CustomName to "Count" the FieldBoxItem for the PropertyAggregateDescription will contain only "Count" and not "Sum of Count".

Hope this helps.

Regards,
Polya
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
PivotGrid
Asked by
Asuman
Top achievements
Rank 1
Answers by
Polya
Telerik team
Share this question
or