Loop through PT
Results 1 to 2 of 2

Thread: Loop through PT
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,400
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Loop through PT

    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
    Code:
    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
    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

  2. #2
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,400
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Loop through PT

    Finally found the issue...

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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •