This sample illustrates the RowPivotOnly mode in PivotGrid. In RowPivotsOnly demo PivotGrid is customized and displayed in a 3D structural format. It customizes the PivotRows, PivotColoumns and PivotCalculation and displays the customized calculation of these data. This normal support has been reframed by calculating data between PivotRows and PivotCalculations excluding the PivotColumns.
Functionality Support in RowPivotsOnly mode:
The below functionalities are implemented in the RowPivotsOnly mode.
1. Sorting.
2. Filtering of PivotCalculation.
3. PivotValueChooser.
Sorting Support:
The PivotCalculation item has been supported with Sorting. Sorting of the PivotCalculation items can be enabled or disabled by AllowSort property.
Filtering Support:
The PivotCalculation item’s has been supported with the Filtering support, whereas the PivotRows will not be supported with Filter’s. This operation can be enabled or disabled using AllowFilter Property.
Pivot Value Chooser:
Pivot Value chooser is a customized dialog which showcases the available Pivot Calculation items in a context menu. From the available PivotCalculation items the user can choose between the required pivotitems.