how to remove Coulmn vertical Zero values in Pivot drill down?

[#1]

Hi how to remove zero values 2016 -2 and 2019- 2  zero values

i want to remove whole zero columns from above pivot drill down table

if we expand + symbol the drill down contains quarter and month values

please  help

[#2]

no one

[#3]

any one please help me

[marcus_sommer]

If your columns 1 or 2 are expressions than you couldn't remove them unless the results for all columns of 2 is 0 or NULL - which isn't in your case. If they are dimension-values you could set them to 0 or NULL and suppress them with an option within the tab presentation (left side).

- Marcus

[#5]

Hi Chaganti,

You need to replace zero values or you want to remove zero value column

[Anonymous]

Hi Chaganti

Hope i got you right

Try and add this string for the integer Format Pattern on the Number tab in the chart properties:

#,##0;-#,##0;

it formats positive and negative value, and leaves blank in other case

worked for me