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

Custom and/or multiple Grand Total columns

1 Answer 30 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Chris
Top achievements
Rank 1
Chris asked on 01 Aug 2014, 04:39 AM
Hi there.

I have a pretty straight forward pivotgrid with 12 columns (months) with a grand total column.

I want another column after the grand total that shows me the monthly average value. i.e. grand total value divided by 12 (the number of PivotGridColumnFields). 

Is this possible?

I saw this thread but the solution would generate a column after each month column which is not what i'm after as described above.
 
Thanks
Chris 

1 Answer, 1 is accepted

Sort by
0
Maria Ilieva
Telerik team
answered on 05 Aug 2014, 02:01 PM
Hello Chris,

Thank you for contacting us.

The online demo below presents how Calculated Fields (the average fields that appear for each item) and also Calculated Item could b created.
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/calculations/defaultcs.aspx?isNew=true

For the purported of your application you should simply create only a Calculated Item (the "Forecast for 1999" item in the demo) which calculates the average value.

I hope this helps.


Regards,
Maria Ilieva
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
PivotGrid
Asked by
Chris
Top achievements
Rank 1
Answers by
Maria Ilieva
Telerik team
Share this question
or