Loop through PT

[mikeymay]

I have a PT that is created from a Power Pivot table and I want to loop through each item in the 1 column of the PT.

I thought the following would work

Set ptField = ptPivotTableList.PivotFields("Proper Name")

but I am getting a 1004 error, Unable to get the PivotFields property of the PivotTable class

I know the ptPivotTableList variable is working as I have used in a previous line of code

ptPivotTableList.PivotFields("[tbl_FAASM].[Region].[Region]").ClearAllFilters

I have no idea why thsi won't work as I have used it many times before.


TIA

 

[mikeymay]

Finally found the issue...

Set ptField = ptPivotTableList.PivotFields("[AD Expected].[Proper Name].[Proper Name]")