Example of Show/Hide Totals in Blazor Pivot Table Component
This sample demonstrates showing and hiding grand totals and sub-totals, as well as change their position in rows, columns, or both at runtime. Also, end users can specify and hide sub-totals of specific fields.
Grand Total |
|---|
| Grand Total | No records to display |
Properties
Totals:
|
Grand totals position
|
Hide grand totals
|
In this sample, you can control the position and visibility of the grand totals and sub-totals by selecting options from the Totals drop-down list. The following options will be displayed based on the drop-down selection:
Grand totals position |
: Allows to display the grand totals either at top or bottom of the row and column axes by selecting the appropriate radio button options. To display the grand totals at top, set the property PivotViewDataSourceSettings->GrandTotalsPosition as Top. And, to display the grand totals at bottom, set the property PivotViewDataSourceSettings->GrandTotalsPosition as Bottom. |
Hide grand totals |
: Allows to hide grand totals in row, column, or both by selecting the appropriate radio button options. To hide grand totals in both row and column, set the property PivotViewDataSourceSettings->ShowGrandTotals as false. To hide the row and column grand totals separately, set the property PivotViewDataSourceSettings->ShowRowGrandTotals and PivotViewDataSourceSettings->ShowColumnGrandTotals as false. |
Sub-totals position |
: Allows to display the sub-totals at top, bottom, or default position of the row and column axes by selecting the appropriate radio button options. To display the sub-totals at top, set the property PivotViewDataSourceSettings->SubTotalsPosition as Top. And, to display the sub-totals at bottom, set the property PivotViewDataSourceSettings->SubTotalsPosition as Bottom. |
Hide sub-totals |
: Allows to hide sub-totals in row, column, or both by selecting the appropriate radio button options. To hide sub-totals in both row and column, set the property PivotViewDataSourceSettings->ShowSubTotals as false. To hide the row and column sub-totals separately, set the property PivotViewDataSourceSettings->ShowRowSubTotals and PivotViewDataSourceSettings->ShowColumnSubTotals as false. |
Hide sub-totals for specific field(s) |
: Allows to hide sub-totals for specific fields in row and column by selecting appropriate fields from the multi-select drop-down. To hide sub-totals for a specific field, set the ShowSubTotals property as false inside the field definition. |
More information on the totals feature can be found in this documentation section.