• Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • Fabric
  • Fabric Dark
  • High Contrast
Theme Selection
Mode Selection
*Translated by Google Translator.

Example of Show/Hide Totals in ASP.NET MVC 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.

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.