How to sort pivot table?

[RADO]

I will appreciate advice on how to sort a desired pivot table column field
in VBA.

I tried Sort method, but VBA help is very unclear on how to use it with
pivot tables. What should be "key1" in this case?

Thanks in advance -

RADO

 

[Tom Ogilvy]

You have to sort the table based on the value in a row field.