Aggregation values ​​in a pivotGrid

4 posts, 0 answers
    ZOUBAI avatar
    1 posts
    Member since:
    Dec 2013

    Posted 20 Feb 2014 Link to this post

    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.

  2. Rosen Vladimirov
    Rosen Vladimirov avatar
    640 posts

    Posted 24 Feb 2014 Link to this post

    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.

    Rosen Vladimirov
  3. UI for WPF is Visual Studio 2017 Ready
  4. OlivierDoucy
    OlivierDoucy avatar
    2 posts
    Member since:
    Mar 2009

    Posted 24 Feb 2014 in reply to Rosen Vladimirov Link to this post

    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
  5. Rosen Vladimirov
    Rosen Vladimirov avatar
    640 posts

    Posted 27 Feb 2014 Link to this post

    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.

    Rosen Vladimirov
Back to Top