HIDE ZERO VALUES FROM A CALCULATED FIELD IN A PIVOT TABLE

[bhanjic]

Hi everyone,

I have a calculated field by the pivot table called "Difference From". I did this, through the value field settings.

Now that I have the sales differences from one period to another, I wanted to hide zero difference values.

Can someone help me?

Thanks in Advance

Chirague

 

[aann]

would adding this formula to the calculated field "difference from" make sense? IF(FieldA-FieldB=0," ",FieldA-FieldB)

 

[bhanjic]

Hi,

Thanks for your post.

The idea was to find a functionality within the pivot table to hide zero values.

The difference from is not a formula cell is something that is part of the pivot.

On a pivot table if you right click, you get value field settings and then on the "show values as" you can automatically calculate the differences from both fields.

The issue here is to hide zero differences.

Hope is more clear.

Thanks

 

[bhanjic]

Could anybody help on this?

Thanks

CB

 

[keymaster]

@CB.. you can use a custom format rule to hide 0s in the display. For this,


1. Go to value field settings of your calculated field.

2. Click on number format

3. Select format type as Custom

4. Type

General;;;

5. Click ok and close everything