Ranking in Pivot Tables

  • Thread starter Thread starter Alan S
  • Start date Start date
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
 
If you right click or doubleclick the grey main field header of the PT
and select Field/Advanced you will see numerous sort options.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rank in Pivot Table 3
Rank Error in Pivot Table 2
Rank items in Pivot Table 3
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Can I do a RANK calculation in a Pivot Table 3
duplicate rank issue 2
Pivot Table question or a simpler suggestion 2
Pivot Tables - Ranking Values 1

Back
Top