I have a number of dimensions, for example Project Manager, Phase Manager and Task Manager, all of which could be different within a specific record or different within a specific record. I put all 3 of these dimensions as Filters on my worksheet. Right now the condition used between this filters is AND. In other words, the values that show in worksheet work as such:
Project Manager = John Doe AND Phase Manager = Jim Doe AND Task Manager = Jane Doe
My values are only representative of all of the Filter criteria. However, I would like to use the OR operator, as such:
Project = John Doe OR Phase Manager = Jim Doe OR Task Manager = Jane Doe
Is this type of arrangement for filters possible? And if so, how would I construct that?
Any help is greatly appreciated.
Rob, thanks so much for the quick response. I am sorry if my follow up question is a dumb one...but, I am not sure I understand option #1. If I create that calculation, where would I use that to actually filter the data?
One thing I should have probably mentioned in my original post is that the data source in this scenario is SSAS olap cube. So, unfortunately option #2 won't work with a cube data source.
But, I am encouraged by option #1...I just need more information on how I would apply this in my scenario. Any additional help would be sincerely appreciated. Thanks!
