Custom and/or multiple Grand Total columns

[Chris]

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 

[Maria Ilieva]

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