Suppose below is your data-source and I need a filter which can select Top N (Top 2)
This should be the desired output. (B and D from India , A & E from USA )---->Top 2 players where a gold medal is given a 100 weight, silver is given 50 & bronze is given 25
Turn rank to continuous and set the Filter as required. (In your case 1-10 )
Show as filter and your slider filter is ready .
I am guessing that you might have used TOP N approach but then kindly keep in mind that
----->TOP N will be filtered first at table level and not country level so you might not be seeing the desirable result there.
So, when you select Top 5 it will be mixing both the countries.
NOTE: If you have a filter for the country as well then you can make use of CONTEXT filter but I think that you are not doing that , I have posted my article on a similar situation here --> Order of Operations
Please find the attached sheet as well. All the best !
Please set this as CORRECT/HELPFUL so that it can help others as well.
topnn.twbx 1.2 MB