Macro to filter pivotable field, print to pdf & repeat to the next item in that field

Hi Everyone,

I need some help to create a macro which will only filter one of the 6 field items in my Pivot Table, print to PDF, save in folder destination with filtered name and repeat through all the items in that specific field.

I managed to get the macro below however I cannot filter on the correct field and I need to filter through
each item(select/deselect).

I appreciate your help!

Please Login or Register  to view this content.

This works for me....

Please Login or Register  to view this content.