Hi There.
First time to the forum, but a long time reader!
A dimension I'm using as a filter in my worksheet has a "Null" option as one of the selectable options in the filter. I want to force the "Null" option to be selected whenever a different selection is made. (I.e. selecting "X" in the filter, causes "X" and "Null" to be selected).
Would appreciate any help on this.
Thanks in advance.
Garrett
Message was edited by: G Maguire - Apologies, very slight refinement of problem from initial post
I know this is a really old post but I spent a while trying to find a solution and figured out an alternative. I couldn't find anything on the forum so thought I'd post this in case it is useful to someone else.
I had a similar problem where I needed one value to always be displayed in the view but wanted the user to be able to select from all of the remaining values.
I created a worksheet that simply had the column that needed to be filtered (see image below). The value "*Map Display*" is the value I always needed included.
Then I created a parameter that referenced that worksheet when the workbook is opened.
Next I created a calculated field with a simple if statement that yields a 'T' value if either the parameter value=the column value or the column value = '*Map Display*'
Finally I use this calculated field as a hidden filter that exclude values equal to 'F'. The user selects the value from a drop down list and the display shows their selection + the '*Map Display*' Records.
The downside to this is they can only select a single value at a time, but that worked for my case.
