Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I have pivot report I want to hide all values having zero's or null or - in , I tick option supress when values is null
option but still I am not able to hide this values.
please help me to achive the same .
Thanks
Vikas
This does not work because, if one of your fields has 0 or '-' or NULL the other field has value for that record. if you want to hide the row for a certain field's content (0 or null or '-') then you have to put a conditional expression(presentation tab) for all the columns with same expression.
Hope this helps.