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
Orienting pivot table values
You can choose to display a pivot table in a columnar or row-based format. Columnar is the default. When you change to a row-based format, a column with the value name is added to the right of the row header column.
To change a pivot table format
-
On the analysis page, choose the pivot table visual that you want to edit.
-
Expand the Field wells pane by choosing the field wells at the top of the visual.
-
On the Values field well, choose one of the following options:
-
Choose Column for a columnar format.
-
Choose Row for a row format.
Note
If you use only one metric, you can eliminate the repeated header by formatting the visual and styling it with the Hide single metric option. For more information, see Font and style on visual types in QuickSight.
-
