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

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on 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 column or row header that you want to hide, and then choose Hide.

    This is an image of hiding a pivot table column.

    Or you can choose the field in the Rows or Columns field wells, and then choose Hide.

    This is an image of hiding a pivot table column.
To hide values in a pivot table

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

  2. In the Fields well, choose a field in the Values field well, and then choose Hide.

    This is an image of hiding a pivot table value.
To show a hidden field in a pivot table

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

  2. In the Fields well, choose the field in the Rows, Columns, Values field well, and then choose Show.

    This is an image of showing a field in a pivot table.
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. In the pivot table, choose any column or row header, and then choose Show all hidden fields.

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

    Or you can 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.