Arrange Values in a Pivot table from the value fields

[susanaolivo]

Hi,
I have a Pivot tabla and under Row fiels I have names from A to Z. Under drop value box are the total sales.
I need to arrange the total sales so the highest is on top and lower amount below and the names move along.
Example:

Jeff 10,000
Zack 300
Mario 30000

I need to see:

Mario 30000
Jeff 10000
Zack 300

I hope someone can help.

Thanks,

 

[Oeldere]

Data => sort => sort on amount => desending

It works, i tried it in a pivot table.

 

[pjpassa]

In the column you want to sort, right click on any data value, say 300. In the context menu, highlight sort, the click sort largest to smallest. It won't work if you click on the column label, because that sorts the arrangement of columns for some reason.

 

[susanaolivo]

In the column you want to sort, right click on any data value, say 300. In the context menu, highlight sort, the click sort largest to smallest. It won't work if you click on the column label, because that sorts the arrangement of columns for some reason.

Thank you!!! it worked!!