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
0
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
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.