how to calculate the rank..

[Anonymous]

Hi Everyone,

We have a table  as given below , I want to calculate state and country wise rank,

here we are taking two dimension Person and State , and in expression we have given =Sales,

=Rank(sum(Sales)) as State Rank and   =Rank(TOTAL(Sales)) as Country Rank.

Now its working but we want  state wise rank without passing the dimension of state in the chart.

Please anyone help me to do this .

Thanks in Advance..

Person	State	Country	Sales
A	UP	INDIA	100
B	MP	INDIA	200
C	MH	INDIA	300
D	UP	INDIA	400
E	MP	INDIA	500
F	MH	INDIA	600

[jerem1234]

I think you have the same problem as:

Finding a Rank

Please find the some of the solutions there.

Hope this helps!

[Anonymous]

thanks jerem.