I have the following dimension set up to only show Res Id with the following values but I also need to extract the data if the
GP ID is equal to CTL01
Is there a way for me to do a match if either one exists????
=if(Match([Res ID],'100529','400068','104198','609022'),'ABC Supply')
=if(Match([Res ID],'100529','400068','104198','609022') or [GP ID] = 'CTL01','ABC Supply')
This might do what you need.
if I need to add another layer such as
an and ID = 39 or id not equal 39
in other words (if the res id = '100529', etc, or gp id = CTL01 ) and id = 39
would this be possible?????
You can simply use
=if(Match ( [Res ID], 100529,400068,104198,609022),'ABC Supply') or Match( [GP ID] = 'CTL01','ABC Supply')
And ID = 39
you can add and or condition to your if as needed
if( (match(....) or match(.....)) and (match(.....) or match(.....)), ...) as ....
Retrieving data ...