Since you have not enclosed any file, I developed a workbook based on my understanding. I assume that challenge is using 'All' value in a parameter.
Please go through the attached file and let me know if this approach works for you.
Hi all! Thanks for your answers. I can't get what I want. I had the option to change the value from top n to all previously. What I wan right now is someway to change the value of my TOP 1. Actually it's like TOP 1 value. My PARAMETER1 is a list of strings (So I can't use it on this top).
This is my top actually
I'm thinking someway to change another parameter2 value (which will be used in top N) regarding the selected value in PARAMETER1.
something like this:
- If Parameter1 ='ALL' then 10000 Else 1 END
- Top PARAMETER2 by count IF .....
Try something like this in your top n formula
count(IF [UNIT TYPE] = '0' AND ([MUNICIPIO] = [YOUR PARAMETER] OR [YOUR PARAMETER] = 'All') THEN .....)
If you are using filter option for defining Top N then you will always get fixed number of records as defined. In this case 1.
Please go through updated file. It has a parameter to select Top N value for other than 'All' parameter value. For 'All' option it gives complete list as required.
If this is not what you want can you share sample file so that it will help all of us.
Thanks both of you but still facing same error
Vijay Kulkarni, I just checked your workbook and it's working as I want. The problem is that my Parameter's List is huge (it has more than 200 records). How can I modify the Selected Parameter and Selected Top Tanks function for cases like this? I must list all parameters like this:
IF [Parameter to select]= 'Parameter#1' OR
[Parameter to select] = 'Parameter#2' OR
[Parameter to select] = 'Parameter#3' OR
[Parameter to select] = 'Parameter#4' OR
[Parameter to select] = 'Parameter#200'
THEN [Rank]<=[Top N]
or there's a way to achieve this easier?
It works! Vijay Kulkarni. Now what I want is to filter All worksheets using this data source" by the value with rank 1. How can I achieve that? I tried to put in into the filter but it doesn't work.