Conventional Sorting

You can sort the data in a pivot table using the conventional sort buttons on the standard toolbar.
This will be preserved when the pivot table is refresh

alt textAscending - Sorts the data alphabetically from A to Z, 1 to 100, Jan to Dec and numerically from the lowest number to the highest.
alt textDescending - Sorts the data alphabetically from Z to A, 100 to 1, Dec to Jan and numerically from the highest number to the lowest.

To sort a pivot table, select the field you want to sort and then select the appropriate button from the standard toolbar.
You some reason the black arrow to indicate that you can select a whole field is not always available - external database ??


AutoSort

The AutoSort feature provides a way of sorting the data based on the actual values or totals in the table.
This way the total with the highest number would always be displayed first.
This feature takes precedence over the conventional sorting, so using AutoSort will disable any conventional sorting.
This will be preserved when the pivot table is refresh


Using AutoSort

(PivotTable > Field Settings), Advanced Options.


alt text

You can switch it off by selecting manual.



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext