help

Back

  1. Home
  2. help
  3. How to Create a Pivot Grid Widget
  4. Grand Total and Subtotal Fields in Pivot Table

Grand Total and Subtotal Fields in Pivot Table

Totals are the sum of row or column values in the pivot table. I know that the pivot grid widget allows me to get the grand totals of rows and columns. Similarly, it allows me to get the subtotals of each row group and each column group.

Here, the grand totals for rows are displayed at the bottom of the pivot table below all rows.

GrandTotals for rows

Grand totals for columns are displayed at the right of the pivot table at the end of all columns.

GrandTotals for columns

Here, subtotals for rows are displayed at the bottom of each row group.

SubTotals for rows

Subtotals for columns are displayed at the right of each column group.

SubTotals for columns

These rows and columns are enabled by default, but I can disable them in Grand Totals Settings under the “Properties” column.

Grand Totals settings

Was this article helpful to you? Yes No