in some cases (on another axis) aggregating my values over the year, I would keep the value of the last month of the year (December).
how could I do this?
Thank you very much.
3 Answers, 1 is accepted
answered on 24 Feb 2014, 11:44 AM
May I ask you for more details, as we are unable to understand the requirement based on the current description. If you can provide an image with description where and what you would like to show, it will be a great help for us.
thank you for your reply,
I enclose you images with this message.
In my pivot grid I display the results that match my fields Axis 1 and Axis 2 for the different months of years 2017 and 2018. that's fine.
Now cover, in some cases, for example the "IDX_CHG" object (as a property in this object), when I collapse in 2007, I would have the value "55" (which corresponds to the value of December 2007) and not the sum of the different values of months: 55 + ... +55 = 660.
When a group is collapsed, its value represents the aggregated value of all collapsed cells. It is not possible to apply different aggregate function for the totals. You can try using CellTemplateSelector and show different value when a group is collapsed (the item will be of type Subheading). I'm sending you a sample project demonstrating this approach.