Hello
I dont want any of the total columns to be shown on my XamPivotGrid (using FlatDataSource). How do I control visibility of those?
Ive tried TotalRowStyle & TotalColumnStyle, which could hide the cells, but not he columns.
Any advice?
Hello,
Thank you for posting in our forums.
You can use the LayoutUpdated event for the pivot grid in order to hide all the total rows and columns. Please refer to this sample code in order to see how to achieve this:
pivotGrid.LayoutUpdated += (s, args) =>{ foreach (PivotDataColumn c in pivotGrid.DataColumns) { c.IsVisible = c.IsTotal == false; } foreach (var r in pivotGrid.DataRows) { r.IsVisible = r.IsTotal == false; } };
Thanks for your promt response.
It work, or at lease almost. After hiding the totals, I see some strange "stribes" around the row selector. See screenshot.
Any idea how to remove those?