Pivot table automatically suppressing columns

[ashishpalkar]

Hi There

I have created Pivot table and its automatically suppressing columns when value of the column is Null or 0.

I want to still show users column Header and it should not suppress when become null. Any workaround?

I have tried with un-checking following

1. Suppress Zero-Values

2. Suppress Missing   

Thanks in advance.

[Anil_Babu_Samineni]

You must play around with suppress option only. Don't disable that option and tick the check boxes. Will you provide screen shot of presentation tab?

[MK_QSL]

Select that particular field and tick Show All Values in Dimension tab

Now tick Suppress When Value is Null for all other dimensions

Go to Presentation tab

Untick Suppress Zero Values

[avinashelite]

Null value is coming from Dimension or the expression ?? if its from the expression the presentation tab option should work . if its from the dimension then un-check the suppress null in the dimension tab .

If your still facing the issue share the sample app

[Anonymous]

Hi Ashish ,

Did you checked the expression  ? what exactly used in expression

please share sample data if possible

[ashishpalkar]

Hi Avinash

its coming from expressions. I am using expression as columns and they are suppressing.

[MK_QSL]

Check my suggestion, it should work.