Hello,
Is there any way on XamPivotGrid to hide or remove totals that I don't need?
Thank you.
Hi,
The only way is to set total column’s width to 0. By this way you will hide the column from UI, but it will still exist in data source.
Regards,Todor
Hi Todor,
Can you provide me with the code sample how to set total column's width to 0? I tried to use this property
pivotGrid.GridLayout.Columns[i].ColumnWidth
but it's read only. And is there any way to hide the total rows as well?
Thank you,
Irina
Hi
Unfortunately current version does not support hiding columns or rows. We have planed this feature for 11.1 version of control.
Regards
Todor
Where is this feature in 11.1, now that it has launched
There is not build in property for hide totals, but there is a functionality for hide columns and rows. So using this feature you can easy to hide the columns you don’t want to be visible. Below is sample how you can manipulate columns visibility.
pivotGrid.LayoutLoaded += (s, args) =>{
foreach (PivotDataColumn c in pivotGrid.DataColumns)
{
if (c.IsTotal)
c.IsVisible = false;
}
};
RegardsTodor
That was exactly what I needed, thank you