This content has been marked as final.
Show 4 replies
-
1. Re: Creating Top N Percent Difference Across Months
Yuriy FalJul 1, 2016 11:53 AM (in response to Yuri Kuzmycz)
3 of 3 people found this helpfulHi 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.
Yours,
Yuri
BTW I am Yuri Ivanych :-)
-
2. Re: Creating Top N Percent Difference Across Months
Yuri Kuzmycz Jul 4, 2016 8:09 AM (in response to Yuriy Fal)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.
-
3. Re: Creating Top N Percent Difference Across Months
Yuriy FalJul 4, 2016 9:32 AM (in response to Yuri Kuzmycz)
Hi Yuri
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).
Yours,
Yuri
-
4. Re: Creating Top N Percent Difference Across Months
hari krishna vangapandu Nov 20, 2018 9:31 PM (in response to Yuriy Fal)Hi Yuriy,
That was so helpful. Thanks a lot.
Cheers,
Hari.