Filtering data in excel based on multiple condition

[wisenicesam]

Hi Everyone,

I have a very big pivot table with different criteria based on loan types, years and months. In my excel I have two columns one contains the year-month & another column contains the loan type. I am trying the subsequent data from pivot table based on the year-month & loan types. As part of solution I looped through each pivotitems i.e. loan type, year & month and enable/disabled the visibility of items depending on criteria from two columns. However it is taking too long to execute as it tries to loop through all the items and try to make the visibility true or false.

I added the excel columns and the data I am trying to pull.Also small section of my pivot table.

I will greatly appreciate if someone can suggest me how to solve this problem with less execution time.