VBA: forcing page filter on pivot table

[dhregan]

Hello -

I have a pivot table which includes a page filter using a data field with possible values of "Yes", "No" or blank. The initial setting for the page filter is "Yes". However, there are some situations when the data field is updated to "No" for all rows. When this happens, the page filter flips to "(All)" when the pivot table is refreshed in VBA. Is there a way to force the page filter to remain as "Yes"? I need the result to contain zero values in the pivot table for this use case.

Thanks in advance.

 

[dhregan]

Thank you Dante. I did not try your proposed solution, as I was able to find a workaround that I imbedded into the formula that was referencing the pivot table count.

 

[DanteAmor]

You could also share your solution, to finally understand what you needed.