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?
Thanks.
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?
Thanks.
1 Answer, 1 is accepted
0
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.
Regards,
Antonio Stoilkov
Telerik
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.
Regards,
Antonio Stoilkov
Telerik
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.