1 Reply Latest reply: Nov 7, 2014 3:33 PM by Jonathan Poole RSS

    Null Column

      Hello I have a pivot table

       

      i have several columns
      i use in one column the after expression.
      so i can show the difference between the same columns of two years.

      2014                            2013
        

      number difference       number     difference

      100        50                   50                 -

       

      e.g. 2014 difference from 2013. but the difference column of 2013 is empty. all null values.

      Is it possible to not showing this empty column?

        • Re: Null Column
          Jonathan Poole

          IF the whole column has nothing but nulls or zeroes you can suppress it using these properties circled below.

           

          additionally, a common trick is put an IF expression on the expression to make it zero or null based on a condition... then use these to remove the unwanted rows/columns as well.

           

          Capture.PNG.png