Example of Show/Hide Totals in ASP.NET Core Pivot Table Control

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.

DEMO

SOURCE

Totals:

Grand totals position

Hide grand totals

Sub-totals position



Hide sub-totals




Hide specific sub-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 grandTotalsPosition as Top. And, to display the grand totals at bottom, set the property 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 showGrandTotals as false. To hide the row and column grand totals separately, set the property showRowGrandTotals and 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 subTotalsPosition as Top. And, to display the sub-totals at bottom, set the property 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 showSubTotals as false. To hide the row and column sub-totals separately, set the property showRowSubTotals and 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.