• Material
  • Fabric
  • Bootstrap
  • Bootstrap v4
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse
Localization
*Translated by Google Translator.
Currency
Essential Studio
HOME
All Controls

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

This sample demonstrates showing and hiding grand totals and subtotals in rows, columns, or both at runtime. Also, end users can specify and hide subtotals of specific fields.

DEMO
SOURCE
Hide grand totals
Hide sub-totals

In this sample, you can hide grand totals in row, column, or both using radio buttons available under the Hide grand totals category. To hide grand totals in both row and column, set the property DataSourceSettings->ShowGrandTotals as false. To hide the row and column grand totals separately, set the property DataSourceSettings->ShowRowGrandTotals and DataSourceSettings->ShowColumnGrandTotalsas false.

Also, in this sample, you can hide subtotals for specific fields too. It can be achieved by selecting appropriate fields from the drop-down available under the Hide sub-totals category. To hide subtotals for a specific field, set the ShowSubTotals property as false inside the field definition.