RowSubTotals level

2 posts, 0 answers
  1. Juan
    Juan avatar
    2 posts
    Member since:
    May 2016

    Posted 08 Jul 2016 Link to this post



    I'm trying to limit the RowSubTotals that it's showing in a pivot, I only want the first level of RowSubTotal. I attached a image where show a first subtotal in green, that i want to keep that values, but in it's show in red the subtotal that i don't want to show. Can someone help me?



    Thanks :)

  2. Polya
    Polya avatar
    242 posts

    Posted 11 Jul 2016 Link to this post

    Hello Juan,

    In the current implementation of RadPivotGrid you can hide all subtotals but cannot hide just some of them. You can achieve that by changing the RadPivotGrid's layout - setting its RowSubTotalsPosition property to RowTotalsPosition.None. You can take a look at our "Layouts" example in our QSF demos:

    Another approach might be to collapse the inner sub totals by modifying the rows and columns GroupsExpandBehavior. We have a great example demonstrating how to set the initial expand/collapse state of the RadPivotGrid's groups here:

    Telerik by Progress
    Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Back to Top