Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a requirement where the user will be choosing the value for 'Top N' through an Input box.
The Input Box should have values like 20, 30, 40, ALL. When ALL is selected, it should show all the values in the table and not Top N.
How to achieve this? I am able to do it for 20,30,40 but ALL is a problem. Please advise.
Paramita
Use a formula like:
=count({1}distinct DIMENSION)
in the value for the dimension limits.
Hope this helps!
Use a formula like:
=count({1}distinct DIMENSION)
in the value for the dimension limits.
Hope this helps!
Thanks Jerem... that works !