Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a Pivot Table with 1 Dimension ( A value List with 2 Values "Tax" + "Amount") and several expresions related with the VAT TAX. Not every month these expressions have values, most of the time their value is 0. What I would like to know if it's possible to Hide ( or not tho show) a row (expression) when its value is 0.
Here's a picture
Thanks in advance!!
Hi.
There is a checkbox 'supress zero-values' on presentation tab.
upd:
Ok, but it doesn't work for expressions
If you use QV11 you can show your expression conditionally (toggle check box Conditional on expressions tab and write a check expression).
Hi.
There is a checkbox 'supress zero-values' on presentation tab.
upd:
Ok, but it doesn't work for expressions
If you use QV11 you can show your expression conditionally (toggle check box Conditional on expressions tab and write a check expression).
Ok!! Thanks