Ranking in Pivot Tables

A

Alan S

Hi,

I am trying to create a pivot table that ranks the data,
in decending order. The Table seems to automatically
sort/rank the data based on what is in the row and I
can't seem to find a way to change this so it is ranked
on the data.

Appreciate any help.

Regards
Alan
 
B

BrianB

If you right click or doubleclick the grey main field header of the PT
and select Field/Advanced you will see numerous sort options.
 
Top