Rank function with multiple dimensions

[warrenpress]

Hi,

I need a little help with the Rank function.

I have a chart with Dimensions Owner and Store, and Expression Sum (Sales). I would like to add an expression that ranks the stores sales against all stores, NOT just those within the same owner. I have attached the QVW as well as an XL file of what I'm trying to achieve.

Thanks in advance

W

[anbu1984 · Accepted solution]

=rank(total sum(Sales))

[morganaaron]

Hi Warren,

Just add in the TOTAL qualifier, so your expression would be =rank(TOTAL Sum(Sales)).

Thanks

[#4]

Add the expression

rank(total sum(Sales))

[ashwanin]

Hi

Just Add Total in front of Sum in your expression.

=rank( Total sum(Sales))

[warrenpress]

Thanks. I knew it had be something simple!