4 Replies Latest reply: Jun 15, 2012 12:36 AM by Deepak Kurup RSS

    Supress Null Values in expression of Pivot Table

      Hello,

       

      Below is the chart I have created.

       

      Even though all the values are null, they do not get suppressed.

       

      My dimensions are

       

      Region,

      Country,

      Remote ID,

      Hiring Type (2012 Reductions and  2012 Hiring)

      Classification (Attrition, etc)

       

      My expression is a simple if(Sum(Count)=0,null(),Sum(Count)))

       

      Sample.jpg

       

      How can I suppress these values in the pivot table.

       

      Thanks,

      BK