How to get Rank based on sub totals in Pivot table

[Lakshmanudui]

Hi All,

I have Pivot table and in that having dimensions like Market and Region.

I want to see the rank based on total ,Sub totals and individual for Market and Region.

Can you please suggest me how to get ranks based on totals and Sub totals.

Thanks & Regards,

Lakshman