there is an index option under show values as in the field setting.
you ca also take a look at this: http://support.microsoft.com/kb/151515


wroote:

I have a simple pivot table with Dollar sales in it by Product. Can I
calculate, in the Pivot Table itself, a RANK calculation to show where each
individual Products ranks?

Can anyone help me.

Thanks KEN