Showing and hiding pivot table columns in Amazon QuickSight - Amazon QuickSight

Showing and hiding pivot table columns in Amazon QuickSight

By default, all columns, rows, and their field values appear when you create a pivot table. You can hide columns and rows that you don't want to appear in the pivot table without changing the pivot table values. When you have more than one measure in the pivot table, you can also hide values.

At any time, you can choose to show any hidden fields in the pivot table. When you publish the visual as part of a dashboard, anyone who subscribes to the dashboard can export the pivot table to a comma-separated value (CSV) or Microsoft Excel file. They can choose to export only the visible fields, or all fields. For more information, see Exporting data from a dashboard to a CSV.

To hide a column or row in a pivot table

  1. In your analysis, select the pivot table visual that you want to work with.

  2. Choose the field in the Rows, Columns or Valuesfield wells, and then choose Hide.

    This is an image of hiding a pivot table column.
To show all hidden fields in a pivot table

  1. In your analysis, select the pivot table visual that you want to work with.

  2. Choose any field in the Fields well and choose Show all hidden fields.

    This is an image of showing all fields in a pivot table.