Creating a Pivot Table - Amazon QuickSight

Creating a Pivot Table

Use the following procedure to create a pivot table.

  1. On the analysis page, choose Visualize on the tool bar.

  2. Choose Add on the application bar, and then choose Add visual.

  3. On the Visual types pane, choose the pivot table icon.

  4. From the Fields list pane, choose the fields that you want to include. Amazon QuickSight automatically places these into the field wells.

    To change the placement of a field, drag it to the appropriate field wells. Typically, you use dimension or measure fields as indicated by the target field well. If you choose to use a dimension field as a measure, the Count aggregate function is automatically applied to it to create a numeric value.

    • To create a single-measure pivot table, drag a dimension to the Rows field well, a dimension to the Columns field well, and a measure to the Values field well.

    • To create a multi-measure pivot table, drag a dimension to the Rows field well, a dimension to the Columns field well, and two or more measures to the Values field well.

    • To create a clustered pivot table, drag one or more dimensions to the Rows field well, one or more dimensions to the Columns field well, and a measure to the Values field well.

    You can also select multiple fields for all of the pivot table field wells if you want to. Doing this combines the multi-measure and clustered pivot table approaches.

Note

To view roll-ups for calculated fields, make sure that you are using aggregates. For example, a calculated field with field-1 / field-2 doesn't display a summary when rolled up. However, sum(field-1) / sum(field-2) does display a roll-up summary.