Windows Forms PivotGrid Control Create interactive user interface of Pivot table, build summarizations and highlight specific data KetticPivotGrid Layout Settings in C#.NET
KetticPivotGrid control for Windows Forms contains two different layouts, the Tabular layout and the Compact layout. The Tabular layout shows a data field in a separate rectangle area, in other words, it will show row descriptors in a separate column in KetticPivotGrid, and show for columns descriptors in a separate row in KetticPivotGrid. The Compact layout is to nest the data field descriptors in the same area, as is saved the space while applying a large number of fields. Customize Layouts of KetticPivotGrid Control
The following C# code demonstrates how to set the layout of the column and row headers by modifying the properties of Tabular and Compact.
this.ketticPivotGrid1.ColumnHeadersLayout = Kettic.WinForms.UI.PivotLayout.Tabular;
this.ketticPivotGrid1.RowHeadersLayout = Kettic.WinForms.UI.PivotLayout.Compact;
The C# code below shows the processes of setting SubTotals and GrandTotals to KetticPivotGrid in your .NET Windows application.
this.ketticPivotGrid1.ColumnGrandTotalsPosition = Kettic.WinForms.UI.TotalsPos.First;
this.ketticPivotGrid1.RowGrandTotalsPosition = Kettic.WinForms.UI.TotalsPos.Last;
this.ketticPivotGrid1.ColumnsSubTotalsPosition = Kettic.WinForms.UI.TotalsPos.First;
this.ketticPivotGrid1.RowsSubTotalsPosition = Kettic.WinForms.UI.TotalsPos.Last;
KetticPivotGrid control provides header cells to each aggregate when more than one aggregate description are added. The users of the control are able to display or hide the cells in the column or row headers areas and customize the level of the aggregate descriptions. The C# code below demonstrates how to achieve this.
this.ketticPivotGrid1.AggregatesPosition = Kettic.Pivot.Core.PivotAxis.Columns;
this.ketticPivotGrid1.AggregatesLevel = 1;
| 
