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, and choose one of the following:

    • In the Rows section, choose Show totals to show totals on the bottom row of the visual. Choose Pin totals to keep the totals visible as you scroll through the table.

    • In the Columns section, choose Show totals to show totals on the last column of the visual.

    • 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 subtotals, choose Subtotal and choose one of the following:

    • In the Rows section, choose Show subtotals to show subtotals on rows.

    • In the Columns section, choose Show subtotals to show subtotals on columns.

    • In the Level section, choose one of the following:

      • Choose Last to only show the subtotal of the last field in the chart's hierarchy. This is the default option.

      • Choose All to show subtotals for every field.

      • Choose Custom to customize which fields show subtotals.

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