Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to Rank 2 measure
Rank by units first then if units is equal >> rank by sales
i use like this not work!!
Aggr(Num(Rank(Sum(Units),Sum(Sales)), name)
please help..
Hi @kanchanaporn,
Required Result:
Use this:
=Aggr(
Rank(
Sum(Unit) * 1000000 + Sum(Sales)
),
Name
)
***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***
i use this it work!!! thank you for you help
Aggr(Rank(Sum(Unit) * 1000000 + Sum(Sales),4,1),Name)
Hi @kanchanaporn,
Required Result:
Use this:
=Aggr(
Rank(
Sum(Unit) * 1000000 + Sum(Sales)
),
Name
)
***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***
it try found if same units and sales show like this
i use this it work!!! thank you for you help
Aggr(Rank(Sum(Unit) * 1000000 + Sum(Sales),4,1),Name)