Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table box where I would like to display only those records where a dimension = 0 and not where the dimension =1 but I do not want to do this through making a selection. I have a feeling this is definitely possible but am struggling to make this work. Any help much appreciated.
Use a calculated Dimension, like
IF(MyDim = 0, MyDim)
And then click on "Suppress when value is null"
HTH
Peter
Many thanks Peter.