Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.