Amazon QuickSight
User Guide

Sorting Pivot Tables

In a pivot table, you can change the sort order on any column to sort all rows in the table according to the values in that column. You can only sort by one column at a time. Sorting on a metric based on a table calculation is supported only if the table calculation used is one of the following:

On the visual, or in the field wells, choose the name of the column that you want to sort by. From the context menu, choose AZ for ascending or ZA for descending sort order.

The context menu in the screenshot also offers options to collapse all or expand all for this field, to remove it, or to replace it with another field.

You can sort by a value by choosing the value to get the context menu, which offers sort ascending and descending options. Doing this also works on subtotals.