Finding a Rank

[#1]

hi all

i want to find out Rank of Sales according State without Taking State as dimension in Table

am attaching QVW file  And data File

i have Find out by including  State dimension  in Table

is it possible???

Finding a Rank according to that Dimension Without including That dimension in Table

Thanks in Advance

[MK_QSL]

Aggr(Rank(SUM(Sales)),Person,State)

[sundarakumar]

Hi,

PFA,

Add

=aggr(rank(sum(Sales)),State)

as expression , if you use it as expression you will see it is shown only once for every state,

if you want to show it in every coloum plese use the same in the calculated dimension.

-Sundar

[jerem1234 · Accepted solution]

You're trying to replicate the rank when you add State as your dimension on your table? Then you want to go with Manish Kachhia's formula but with Person and State reversed:

Aggr(Rank(Sum(Sales)),State,Person)

You might also want to rank each state without Person in consideration using the formula:

Aggr(Nodistinct Rank(SUM(Sales)),State)

Please find attached.

Hope this helps!

[#5]

Thanks jerem for Your Fast reply

[sunilkumarqv]

Hi,

check this

Aggr(Rank(Sum(Sales)),State,Person)