Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to hide a row within a straight table?
I have a High Risk Table which currently shows all items but I want it only to show those which match a risk value.
Possible values are High, Low, and N/A
I want to hide all of the N/A ones.
Thanks
Mark.
You could try something like that in your first dimension (assuming the field used is Dimension1):
if([Risk value]='N/A', null(), [Dimension1])
And remember to uncheck "Include null values"
Can you show us your table ?
You could try something like that in your first dimension (assuming the field used is Dimension1):
if([Risk value]='N/A', null(), [Dimension1])
And remember to uncheck "Include null values"
My final expression was:
=IF([DPIA Status] <> 'N/A', [DPIA Status])
This rmoved the whole row once the 'Include Null Values' was un checked.
Thanks
Mark