Forum Discussion
Filter Pivot Table
Ok, i have a filtered pivot table and wonder if there is a way to have an option to select no items and have value show 0 In this case, there are none that have been improperly modified, therefo...
I am using Conditional Formatting or IF Logic Outside Pivot
=IF(GETPIVOTDATA(...)="", 0, GETPIVOTDATA(...))
In view of this, if the PivotTable returns blank due to no matches, your cell shows 0.