Sort in a Pivot Table
 

Greetings,

Need help as I can't seem to get my pivot table to Sort. Want to sort by
ascending or descending based on value in total column of data. I try the
Pivot Table/Sort and Top 1 but only seems to give me option to sort the first
column.

Any help or direction is appreciated.

Thank You!

Sort in a Pivot Table
 

Right-click the first column and select "Field Settings"
There you can sort ascending or descending and specify which field to sort by

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Steve B" wrote:

Greetings,

Need help as I can't seem to get my pivot table to Sort. Want to sort by
ascending or descending based on value in total column of data. I try the
Pivot Table/Sort and Top 1 but only seems to give me option to sort the first
column.

Any help or direction is appreciated.

Thank You!