I'm not sure I completely understand what is desired, however, by creating a calculated field similar to the following and placing it on the view either Y's, N's or both will show when different Regions are being filtered:
if [Region]='West' then 'Y'
else 'N' end
Hope this helps!
What I meant is I want the If filter to be dynamic. E.g.
If I filter the records for West region, then the statement should become
If [Region]="West" then "Y" else "N" end
Now If I change this filter on the filter shelf to East, the statement should become
If [Region]="East" then "Y" else "N" end
Is there any way to achieve this?
This can be done by creating a string parameter and setting the calculation to reference the parameter. I have attached a sample workbook. Hope this helps!
dynamic filter.twbx.zip 1.1 MB