• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Automatically Filter Pivot Table base on specific words


I am using the excel 2013

I have used the recording macro the pivot table, I have not to filter in pivot table the "ZP" and "KZ" (Document Type), whatever this words ("ZP" and "KZ"), to be filtered in the pivot table. In case these words not available, to be visible all items.

Kindly provide the VBA and thanks to advance