8 Replies Latest reply: Jun 13, 2018 7:39 AM by Fatih SAHIN 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