% change columns

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

    Posted 09 Feb 2014 Link to this post

    Hi there.

    I have a pivot grid showing monthly figures. I also give the user the option to change this to quarterly or annually (updates the GroupInterval attribute).

    I need to show % change between months and also between quarters and years when they change the GroupInterval to these intervals.

    I was thinking to create a custom sub total to display these % changes. Would that be the best solution? How would I do that?

  2. Antonio Stoilkov
    Antonio Stoilkov avatar
    530 posts

    Posted 12 Feb 2014 Link to this post

    Hi Chris,

    You could take a look at the help article below where it is described the different Total Formats for aggregate fields. You could achieve your scenario by applying the format to a new aggregate if you want to leave both the calculation and its percent.

    Antonio Stoilkov
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the UI for ASP.NET AJAX, subscribe to the blog feed now.
Back to Top