0 Replies Latest reply: May 18, 2015 2:36 PM by Caio Engelhardt Caminoski RSS

    [Sense] Pivot Table hide Null/Zero problem

    Caio Engelhardt Caminoski

      Hi everyone!

       

      I have a problem that seem really basic and I have no idea how to solve it.

       

      I have a pivot table in my application. The problem is that it is showing a null row/column I can't hide.

       

      Null Row.JPG

       

      I have tried to change all dimension to sth like: "if( not isnull([Field]), [Field])" and my expression to "Sum( {<Qtd -= {'','0'}>} Qtd )"

       

      No need to say that the option 'Show null values" is unabled

       

      If someone have an idea, I would appreciate.

       

      Thank you in advance!!

       

      Caio Caminoski