Adding a pivot table calculation - Amazon QuickSight

Adding a pivot table calculation

Use the following procedure to add a table calculation to a pivot table.

To add a table calculation to a pivot table

  1. Expand the Field wells pane by choosing the field wells near the bottom of the visual.

    Pivot table configuration with Region in Rows, Segment in Columns, and Profit (Sum) in Values.

  2. Choose the field in the Values well that you want to apply a table calculation to, choose Add table calculation, and then choose the function to apply.

    Pivot table interface showing options to add table calculations like running total and percentages.
Note

You can't run Total, Difference, and Percent Difference table calculations when a pivot table is being sorted by a measure. To use these table calculations, remove the sort from the pivot table.