I believe in your case the "All relevant values" (Cascading filter) option is enabled. Right click the filter and chose "All values in database" option.
I cannot find this option as I'm not using the Filter option, but the "Use as filter"
It's a table with some value (Name of offer) that I'm using as filter.
Any other idea?
Can you please elaborate the problem with some screenshots so that i can relate few things and provide you some solutions.
Hi Morgan. I believe you are referring to Dashboard Filter Actions, and not filters within the worksheets, correct? If so, you can customize the effects of the automatically generated actions that were created when you selected "Use As Filter" in the dashboard. From the menu, select Dashboard --> Actions. Then select the filter action and click Edit. From that window, you can select which sheet(s) you want to be the source and which sheet(s) you want the filter applied to. You can create multiple filter actions to work in combination to get the effect you need. Here are a couple of links that provide more details:
It is indeed a Dashboard Filter Action and I just found the solution.
Actually, I am using several sheets that list the countries, the activities, etc.... as Columns (To get the filter horizontal). To remove the "abc", I have created a calculated field called "Blank" with " " as suggested here:
However, this seems to cause some issue....When I select Filter 1, the data is being filtered correctly and when I want to add Filter 2 (To do Filter 1 + 2), when I only got Filter 2 (The Filter 1 is still highlighted, but in the data, it is actually being removed).
If I remove the blank field and just change color of the data in White (Last option suggested in the doc), then it works like a charm.
I don't know the reasons behind this, but I'm happy to find the solution.
Thanks for your help