(v24) Sort Data in a Pivot Table

Sort Data in a Pivot Table

This applies to: Visual Data Discovery

The data in the table can be sorted. After you save the dashboard or visual, the sort settings are retained when you close it. The sort settings are also retained when you export and share the table.

Sort the rows in a table by the data in a single column:

• Select a column to sort the data in ascending order. An up arrow is shown in the heading.

• Select the column again to sort the data in descending order. A down arrow is shown in the heading.

• Select the column again to clear the sort. No arrows are shown in the heading.

• Alternatively, hover over the header and select the More menu () then select Reset [name] to clear all sorting options.

Save the visual when the data is sorted to your satisfaction.

Sort the columns in a table:

• Select a column to sort the data in ascending order. An up arrow is shown in the heading.

• Select the column again to sort the data in descending order. A down arrow is shown in the heading.

• Select the column again to clear the sort. No arrows are shown in the heading.

• Alternatively, hover over the header and select the More menu () then select Reset [name] sorting to clear all sorting options.

Sort the data in a table by the data by one or more column or row groups:

Sort Column groups:

• Select a column group to sort the group from ascending to descending.

• Select the column group again to reverse the sort order, or a third time to cancel sorting.

• To sort by multiple groups, select the next column group to include.

Sort Row groups:

• Select a row group to sort the group from ascending to descending.

• Select the row group again to reverse the sort order, or a third time to cancel sorting.

• To sort by multiple groups, select the next row group to include.

To clear sorting, hover over a column or row label, select the More menu () and select one of the following options:

• Reset [name] sorting to clear all sorting options for that row or column.

• Reset other column (or rows) sorting to clear sorting options for all column or row groups except the one you have selected.

• Reset all columns (or rows) sorting to clear all sorting options for all column or row groups.

Save the dashboard or visual when the data is sorted to your satisfaction.