I am not able to send the workbook I am currently using. Basically create a calculated field which displays a different field set of values for each parameter option. Then filter based on that calculated field.
WHEN "Option 1" THEN [Field 1]
WHEN "Option 2" THEN [Field 2]
Jason -- I want to recommend that you provide a sample workbook -- even if you just hack up something using excel and bogus sheets -- so that the person who wants to help you is working on the same page as you are.
I've seen it too often. A guy does a bunch of work to help someone out, and the assumptions he worked with were not what the original person had in mind.
Maybe Lénaïc will nail your expectations, but maybe not. He's ready to help you, but you need to help him help you.
Please see sample attached.
Parameter = p_Location
Filter = Location Selection
When "State" is selected for the parameter, the user selects "Alabama" for the filter. When the user changes the parameter to "City" there are no values displayed. This is because the filter value retains "Alabama" and there is no match for "Alabama" in [City].
The ideal would be for the change of the parameter to trigger (All) to be selected in the filter.
Superstore_DefaultALL.twbx 632.6 KB