Displaying Totals and Subtotals - Amazon QuickSight

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.

To display or hide totals and subtotals for a pivot table

  1. Sign in to Amazon QuickSight at https://quicksight.aws.amazon.com/.

  2. On the analysis page, choose the pivot table that you want to format.

  3. Choose Format Visual ( ).

  4. 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.

  5. To display totals, choose Subtotal.

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

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

To display or hide totals for a table chart

  1. Sign in to Amazon QuickSight at https://quicksight.aws.amazon.com/.

  2. On the analysis page, choose the table that you want to format.

  3. Choose Format Visual ( ).

  4. Enable Show totals to display a total.

  5. For Position, choose where to display the total, Top or Bottom. By default, totals are displayed at the bottom of the table.

  6. For Totals font size, choose the size of the total. The options range from extra small to extra large. By default, the font size is medium.