Amazon QuickSight
User Guide

Displaying Totals and Subtotals

On tables and pivot tables, you can configure the display of totals or subtotals. Tables can display totals at the top or the bottom of the visual. Pivot tables can display totals and subtotals on rows and columns.

Use the following procedure to display or hide totals and subtotals for a visual.

  1. On the analysis page, choose the visual that you want to format.

  2. Choose the on-visual menu at the upper-right corner of the visual, and then choose Format visual.

  3. If you are using a table, show totals by enabling Show totals. By default, totals are displayed at the bottom of the table. To display totals at the top, choose Top.

  4. If you are using a pivot table, choose one or more of the following:

    • To display totals, choose Total.

      To show totals on each row, enable Show totals on row.

      To show totals on each column, enable Show totals on column.

    • To display subtotals, choose Subtotal.

      To show subtotals on each row, enable Show subtotals on row.

      To show subtotals on each column, enable Show subtotals on column.