PivotItem loop with getpivotdata - hide pivotitem

**csutera** · 01-11-2016, 01:26 PM

Hi,
I'm trying to hide rows of a pivot table based on the sum of pivot items. The code works if I use the name of the pivot item in the getpivotdata function but does not work in a For Each PivotItem loop. Can you identify what I am doing wrong? The 1004 error occurs on line 1 of the loop

Please Login or Register  to view this content.

Example of Pivot Table example1.png
Update at 2:30 pm: this is a filtered page. Code works on the main sheet. Now I'm trying to get it to work on the filtered pages where Company1 may not exist. The code fails when Company1 does not exist.

**dflak** · 01-14-2016, 10:41 AM

Without a workbook I can only speculate. One of the issues with pivot items is that at least one of them must be selected at all times. So say you have four items A, B, C, D and only B is turned off. You want to turn B off and C on. So you write code to do this. If you turn B off before turning C on, you will get an error. Something like this might be happening with your code. I can't tell without seeing the data.

Generally, the way around this pitfall is to turn everything on, and then go back and selectively set what you want.