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

RowSubTotals level

1 Answer 19 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Juan
Top achievements
Rank 1
Juan asked on 08 Jul 2016, 04:33 PM

Hello! 

 

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 :)

1 Answer, 1 is accepted

Sort by
0
Polya
Telerik team
answered on 11 Jul 2016, 03:48 PM
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: http://demos.telerik.com/wpf/

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: https://github.com/telerik/xaml-sdk/tree/master/PivotGrid/ExpandBehavior

Regards,
Polya
Telerik by Progress
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Tags
PivotGrid
Asked by
Juan
Top achievements
Rank 1
Answers by
Polya
Telerik team
Share this question
or