Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
how can i show the branch with highest sale in label?
=FirstSortedValue(Branch, -aggr(sum(Sales),Brach))
Hi omid,
Try this expression,
Num(Aggr(Rank(Sum({1} "Measure"),4),"Dimension"))
rank(sum(Sales))
i used this:
=num(Aggr(Rank(Sum({1} L_COUNT),4),PROVIENCE_NAME))
but it doesnt show any thing
=FirstSortedValue(Branch, -aggr(sum(Sales),Brach))
Tanks Kushal
Welcome