how to i remove certain column in a pivot table

[drohm002]

Hello, please see the screenshot below.  Is there a way to remove the two columns with a red line through them?

[robert_mika]

if all values are null and 0 try to deselected this box 

 

[marcus_sommer]

The general behaviour is that all expression-columns are shown to each available dimension-value - regardless of the results.

You may try like suggested to hide NULL/ZERO results. If it doesn't worked you could remove the appropriate dimension-level and replacing it with expressions.

This means for the shown scenario to remove the HAPI sub-category and using 4 more specialized expressions with an appropriate set analysis to link the calculation to the intended dimension-value and/or applying extra if-loops to check the results against unwanted ones + using the NULL/ZERO settings.

[Chanty4u]

You use 

Label text colour 

=White()

Exp text colour 

=White ()

Reduce column width 

Hope this helps you