Hi, I have a pivot table with all the expense types in one column. I have one thousand expense types so it would be kind of slow if i were to loop through every expense. And I also only want to set .PivotItems(ÄDVERTISING EXPENSES).visible = True. If i were to use the visible = false method, i might have some new expense type next month that will not get filtered away.


Thank you