Custom and/or multiple Grand Total columns

2 posts, 0 answers
  1. chrisL
    chrisL avatar
    64 posts
    Member since:
    Dec 2005

    Posted 31 Jul 2014 Link to this post

    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.
  2. Maria Ilieva
    Maria Ilieva avatar
    4017 posts

    Posted 05 Aug 2014 Link to this post

    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.

    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.

    Maria Ilieva

    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.

Back to Top