Thanks. I'm having a problem filtering a Pivot Table to show only records that have a value equal to zero.
In your experience, is there a general best practice when it comes to zero values in cells where Pivot Tables are concerned and as it pertains to filtering to see what records = 0? Is it better to have these cells represented as, for example: "0", "0.0" or leave them blank?
In your experience, is there a general best practice when it comes to zero values in cells where Pivot Tables are concerned and as it pertains to filtering to see what records = 0? Is it better to have these cells represented as, for example: "0", "0.0" or leave them blank?