Null Column

[#1]

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?

[JonnyPoole · Accepted solution]

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.