1 of 1 people found this helpful
With regards hard coding this something like
[Level1 Manager] = 'Daisy' OR [Level1 Manager] = 'Radha' OR [Level2 Manager] = 'Raymond'
Not sure if you need something more flexible, but this (when filtered to true) should bring you back just those rows
Thank You Simon.
Simon I tried the following code
if[Level1 Manager] = 'Daisy' OR [Level1 Manager] = 'Radha' OR [Level1 manger]='Michael' OR [Level2 Manager] = 'Raymond' then 1 else 0 end.
I converted it to dimension and checked 1 in the filter. I am getting only one row as the result.
Michael and Raymond.
Couldn't retrieve the values from Daisy and Radha.
Ok.Got it.Thanks again Simon.