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.

    • By default, the total appears without a label. To change this, you can enter a custom name for Row totals label and Column totals label.

  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.

    • By default, the subtotal appears without a label. To change this, you can enter a custom name for Row subtotals label and Column subtotals label.

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.

  7. For Total label, enter a custom name for the total. By default, the total displays without a label.