ALL in Dimension Limits

[#1]

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

[jerem1234 · Accepted solution]

Use a formula like:

=count({1}distinct DIMENSION)

in the value for the dimension limits.

Hope this helps!

[#3]

Thanks Jerem... that works !