13 Replies Latest reply: Mar 2, 2016 4:49 AM by kagiso boikanyo RSS

    Pivot Table - how to get rid of "-" or Null value in columns

    Jim Chan

      HI there,

       

      i am working on a pivot table. and i am having this issue. i have null values in all my columns. how get i get rid of that?

       

      i have tried "checcking" suppress when value is NULL. but, once i checked it, other columns will not be displayed.

      error.png

       

      Rgds,

       

      Jim