Hi, how about this approach?
1. Create a parameter "Driver Parameter" with values 1, 2, 4
2. Create calculated field "Physicians = [Driver Parameter]"
3. Create calculated field "[Health Systems and...] = [Driver Parameter]"
4. Add both calculated fields to filters and set both filters to TRUE
Thank you for your suggestion. I tried doing this but for some reason it would exclude all of my values except for “Not a Driver”. This is the current view of my worksheet. What I’m trying to accomplish is having one filter where you can click on any of the 3 drivers, and see them across the two dimensions. Example- clicking on “key drivers” and seeing all of the key drivers for Health Plans and the State Legislation dimensions as well.
image001.png 376.2 KB