Rank by Conference

[bbi_mba_76]

Hi,

in the attached pivot I want an expression to calculate the rank by conference, ie in Eastern Conf. Toronto should be the first and Philadelphia the last one.

Could you help me? Thanks

[#2]

According to this thread, you might need to change to table (I already did, it ordered them by Conference then Rank), so that would be an easy solution.

[bbi_mba_76]

I would like to have the expression, so if I select two divisions of the same conf I have the related rank.

[rubenmarin]

Hi Michele, you can try with:

Aggr(rank(total sum({<Conference={'Western Conference'}, Division=,Team=>} W/(W+L)),4,1), Conference, Division, Team)

& Aggr(rank(total sum({<Conference={'Eastern Conference'}, Division=,Team=>} W/(W+L)),4,1), Conference, Division, Team)

[jerem1234 · Accepted solution]

Try:

aggr(rank(sum({<Division=,[Team]=>} W/(W+L)),4,1), Conference, Team)

Hope this helps!