Rank Sum Issue

[dineshm030]

Hi All,

The rank is not coming for remaining region while selecting Punjab region. I want to show the rank based on region brand groups.

Expression: 

Aggr(Rank(Sum({<[Brand groups]>}NVALUE),1,1),[Brand groups])

,

[thevingo]

try

=Aggr(Rank(TOTAL Sum({<[Brand groups]=, Region=>} NVALUE),1,1),[Brand groups])

[dineshm030]

its not working... i want to show the rank all region.

[elmardi0107]

Hi Dinesh,

You have just to reverse the formula as below:

Rank(Aggr(sum),city,Produit))

Rank before Aggr.

Hope that's help.

[sunny_talwar]

May be this

Only({<Region, [Brand groups]>}Aggr(Rank(Sum({<Region, [Brand groups]>}NVALUE),1,1),[Brand groups]))

[olivierrobin]

hello,

and with TOTAL <region> ?

[elmardi0107]

Hi Dinesh,

You have just to reverse the formula as below:

Rank(Aggr(sum),city,Produit))

Rank before Aggr.

Hope that's help.