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, therefore i have none to select, as all the ones listed or correct. I need a way to make it show 0. Here is show 36, which is all of them, since i'm not sure how to do this so i can select none and show 0?
3 Replies
In my case, the filter has a list of CI names, all of which are correct, therefore I have no incorrect ones to select, but it makes you have at least one selection.....
In my case, the filter has a list of CI names, all of which are correct, therefore I have no incorrect ones to select, but it makes you have at least one selection.....
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.
