Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new in QV and I need their help.I have a list of categories that have associated to a quantity for month, the categories they are my dimensions, in a chart pivots and the quantities are my expressions.As I can show alone the dimensions that have the biggest quantity that 0?.
Thanks
Hi,
Something like this could work:
If(Sum(Value)<0,0,Sum(Value))
Then just make sure that the option to supress zero is on in Presentation.
Regards,
Stephen