Forum Discussion
Solved
Top 10 does not work correctly
Hi everyone, I have a problem on my mesure and I don't know why. I try to do a TOP10 of YTD quantity by Customers. I want the TOP 9 Customers and the last will be the "Others" customers. ...
HI A_Barny,
You can add new calculate to replace top 10 values, then use new column as category.
Category = IF([TOP 10]<>"Others",[Customers],[TOP 10])
Regards,
Xiaoxin Sheng
HI A_Barny,
You can add new calculate to replace top 10 values, then use new column as category.
Category = IF([TOP 10]<>"Others",[Customers],[TOP 10])
Regards,
Xiaoxin Sheng