Pivot Table - Hide Calculated Zero Fields
Posted on 2007-03-22
I have a pivot table query which contains calculated total fields. These calculated fields default to zero if the calculation cannot be performed (due to division by zero, etc).
Currently, all fields (row fields) are visible - even those with a calculated value of zero. However, I would like to hide these.
Is there a setting I'm missing? Should I change my formula to default to null? Ideas?