I have a little succes with this using a modified version of
http://kb.tableausoftware.com/articles/knowledgebase/filtering-multiple-dimensions-using-parameters and the Case statement below.
CASE [Parameters].[Vulnerable Filter]
WHEN 'Ethnicity' then
IF [ETH] = [Vulnerable Filter On] THEN "Show" END
WHEN 'FSM' then
IF [FSM] = [Vulnerable Filter On] THEN "Show" END
WHEN 'RD' then
IF [RD] = [Vulnerable Filter On] THEN "Show" END
WHEN 'YC' then
IF [YC] = [Vulnerable Filter On] THEN "Show" END
It works as it should and Filters correctly for each of the selections. My only issue now is that I also want to show all records and cannot workout how to clear the filter. I know this is simple but I just cannot see how to clear the filter.
Add an option to your parameter for "All" or "Show All" and then in your calculated field CASE statement add the following two lines:
WHEN "Show All"
Thanks for the reply and I apologise for my delay as I have been on Vacation.
That works as described.
Is it possible to set out the above as multiple Select rather than just a single.
Unfortunately, parameters currently only allow single select. Given your problem description, I think you'd need to reshape your data so those 8 columns become 1 and then you can use a Quick Filter.