Analytics Software

Hi,


http://rapidshare.com/files/401755613/Kishore.jpg.html


please download the file by using link. that is the snapshot of my requirement.



I wand to display the rank based on the value seleted on the column selector


The Rank should be applied based on the grand total

If i select Regions in the column selector i need to apply rank to the grand total of the dollars by region wise

like wise

If i select markets in the column selector i need to apply rank to the grand total of the dollars by market wise



so , dynamically i need to set the formula of rank column

can anybody help on this



Thanks & Regards
-------------------------
Kishore P