Hi All,
I have created a set on a dimension - caseid and have a view which has got
500 cases for 'in'
and
20 cases for 'out'.
Would like to know how should I apply a filter so that I can see only the top 10 in each 'in' and 'out' .
Regards,
Rishi
Hey Rishi,
You can use Rank function to achieve what you want. I've used superstore data to demonstrate.
1. Created a set to replicate your scenario.
2. Create a RANK function which takes in the sum of profits. In your case whatever measure you want to use to filter the top 3. Convert this calculated field to discrete.
3. Add the Rank to the filters.
4. Now edit table calculation such the rank is calculated such that it restarts at every value of your set.
5. Now filter out for 1, 2 & 3.
Let me know if this helps.
Regards,
Rohit
