Find my approach based on rank-functionality as reference stored in attached workbook version 9.3 located in the original thread
Step 1: define parameter
Step 2: define rank
Step 3: define selection
show??: [rank]<=[Top N]
Step 4: Drag all required objects to the right location
Rankuser_nalmai.twbx 39.6 KB
Thanks it worked but there is a following bug issue occurred.
1. Show Filter - When I click America it is displaying and in same way APAC & EMEA
2. But My problem when I select all the 3 region in the filter usually it should show all the region but it is only showing America as the first .
3. When uncheck all one by one region if I click it is working fine.
4. How to solve this issue? I want to see all region wise sales together.
If possible please help me
It'll be more helpful for us to analyse If you share some sample data in .twbx or .xls format.
As per my understanding, 1st. create a calculated field and use the calculation =Index(), go to advance partition by username, region.
sort by Sales ---> Sum---> desc.
Change level Region.
Put this calculation as filter and use the range 1 to 10.
Put Sum(Sales) in Coln.
Put Region, UserName in Row.
Hope you will get the result.
The same I had explained with Index(). Pls. check...