Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
no one
any one please help me
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
Hi Chaganti,
You need to replace zero values or you want to remove zero value column
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