Dear all,I need to do a calculation on columns Division and Balance , such that - " for Divisions sorted on sum(balance), the sum of balance for top 5 divisions."
Am using the expression -sum({<DIVISION = {"=rank(aggr(sum(BALANCE),DIVISION))<= 6)"}>}BALANCE), but it seems to fail as the rank function returns a number, and I need the Divisions for top 5 ranks.
