Slicer select automatically

[kirana2014]

Dear all,
I want to select the slicer automatically with value = 0
when the pivot table refresh, Someone who knows how to make this work?
Thanks for your help / alternative solution ideas.

[Bo_Ry]

Please put this code in Sheet Pivot

Please Login or Register  to view this content.

[kirana2014]

Dear Bo_Ry

Is working

Thank you

[kirana2014]

It's possible if on pivot table the value 0 not found clear the filter

thank you