If you right click the dimension, you can create a set and check the two fields that you want. Let me know if this helps
1 of 1 people found this helpful
I would have two Attribute parameters. Attribute-1 and Attribute-2.
I don't know of a way to limit the filter.
Well, yes. You can use LODs to know how many the user has chosen. Once two are chosen you can hide the filter altogether. But then there is no way to un-set the selections to get the filter back into view.
Two params. Then have a calc like this:
If [Attribute] = [Param1] or [Attribute] = [Param2] then 1 else 0 END
Put that on filters, and select for value =1. You'll get the two attributes on the sheet.
Thanks! This is helpful. Since I want to keep the options open to the viewer to choose the value that they want, I can't preselect them at this time. Thank you
Hey David if you found it helpful please click Yes on my reply or mark it as the correct answer. I'd really appreciate it!
Thank you! This worked perfectly. Appreciate it