Forum Discussion
tyan
Helper II
Helper IITOP 5 and Button 5
This is the raw table. Store Name Season Rating A 2021SS 10% B 2021SS 10% C 2022SS 5% D 2022FW 5% E 2022FW 5% F 2022SS 19% G 2023FY 2% H 2023FY 9% I ...
MFelix
Super User
Super UserHi tyan ,
On your dataset the top 5 includes the store A and B if you use the TOPN on the filter the repeated values all appear, I have made some changes and added a Z store with 15% so has you can see altough I have Top5 it shows me 6 because there are two stores with 10%
In this case your issue is that you don't want to present both stores?
You can also make a raking measure but has you can see stores with equal values get equal rankings: