This is a migrated thread and some comments may be shown as answers.

Aggregation values ​​in a pivotGrid

3 Answers 19 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
ZOUBAI
Top achievements
Rank 1
ZOUBAI asked on 20 Feb 2014, 10:58 AM
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

Sort by
0
Rosen Vladimirov
Telerik team
answered on 24 Feb 2014, 11:44 AM
Hello Zoubai,

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.

I'm looking forward to hearing from you.

Regards,
Rosen Vladimirov
Telerik
0
OlivierDoucy
Top achievements
Rank 1
answered on 24 Feb 2014, 05:11 PM
Hello Vladimirov,
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.

Thank you again
0
Rosen Vladimirov
Telerik team
answered on 27 Feb 2014, 03:11 PM
Hello Olivier,

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.

Hope this helps.

Regards,
Rosen Vladimirov
Telerik
Tags
PivotGrid
Asked by
ZOUBAI
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
OlivierDoucy
Top achievements
Rank 1
Share this question
or