3 of 3 people found this helpful
Hi Yuri Kuzmycz,
Since % difference is a Table Calculation,
you may want to use another Table Calc for sorting -- namely,
the one using RANK() function -- and a Table Calc filter on top of that.
Please find the attached as an example.
Hope it could help.
BTW I am Yuri Ivanych :-)
HUGE thanks for the help! Works exactly as I wanted. Two quick questions:
- Is there a way to hide the rank?
- How did you change your parameter control to a slider? Mine only allows a value typed.
Glad it worked for you.
1. Right click on Rank pill on Rows --> clear Show Header flag
2. Parameter [Top Customers] --> Edit --> Allowable values --> Range
This triggered a slider by default. Also Slider is an option for List (but not for All).
That was so helpful. Thanks a lot.