Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
aggr(rank(sum({<Division=,[Team]=>} W/(W+L)),4,1), Conference, Team)
Hope this helps!
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.
I would like to have the expression, so if I select two divisions of the same conf I have the related rank.
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)
Try:
aggr(rank(sum({<Division=,[Team]=>} W/(W+L)),4,1), Conference, Team)
Hope this helps!