6 Replies Latest reply: Dec 16, 2015 9:07 AM by Sunny Talwar RSS

    How to suppress ZERO values in pivot table

    Rubens Rodrigues

      Hi folks,

       

      It sounds a very easy issue, but I need some help. I have the following scenario:

       

      Pivot 1:

       

      ClientPrice APrice BDifference
      Client A50-5
      Client B550
      Client C550
      Client D50-5
      Total2010-10

       

      I need to suppress the clients that DIFFERENCE = 0, so having the following result Pivot:

       

      Result Pivot:

       

      ClientPrice APrice BDifference
      Client A50-5
      Client D50-5
      Total100-10

       

      I have already tried something like "IF( PRICE B - PRICE A <> 0, SUM(PRICE A)) and  IF( PRICE B - PRICE A <> 0, SUM(PRICE B))" in order to calculate the PRICE A and PRICE B, then the Clients that difference = 0 were suppressed. However, the TOTAL kept the same as has been shown above in Pivot 1.

       

      Could anybody help me with this?

       

      Thanks in advance.

       

      Rubens Rodrigues