Results 1 to 6 of 6

Thread: Getpivotdata
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2008
    Posts
    102
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Getpivotdata

    Hi

    Would appreciate any help with this GETPIVOTDATA, I need to make it dynamic, and link &[2.018E3] to a year in a cell and&[1.] to week in a cell. I've tried a few things but nothing is working.

    =GETPIVOTDATA("[Measures].[MP Count]",'[3Data.xlsx]ATT ENT'!$A$4,"[Subscriptions].[Attend Type]","[Subscriptions].[Attend Type].&[3MONTH]","[Subscriptions].[Trans Type]","[Subscriptions].[Trans Type].&[ATT]","[Subscriptions].[Start Fiscal Year]","[Subscriptions].[Start Fiscal Year].&[2.018E3]","[Subscriptions].[Start Fiscal Week]","[Subscriptions].[Start Fiscal Week].&[1.]")


    Thanks for your help.

    Gavin

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,990
    Post Thanks / Like
    Mentioned
    53 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Getpivotdata

    What exactly is in the two cells, and what did you try that didn't work?

  3. #3
    Board Regular
    Join Date
    Apr 2008
    Posts
    102
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Getpivotdata

    Hi Rory, C2 = 2018 and C1 = 1, I've also tried '2018 and '1 and 2.018E3
    I've tried "[Subscriptions].[Start Fiscal Year].&["&C2&"]" , "[Subscriptions].[Start Fiscal Year].&"&C2 , "[Subscriptions].[Start Fiscal Year]","[Subscriptions].[Start Fiscal Year].["+C2&"]"
    Thanks
    Gavin

  4. #4
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,990
    Post Thanks / Like
    Mentioned
    53 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Getpivotdata

    Does this work:

    =GETPIVOTDATA("[Measures].[MP Count]",'[3Data.xlsx]ATT ENT'!$A$4,"[Subscriptions].[Attend Type]","[Subscriptions].[Attend Type].&[3MONTH]","[Subscriptions].[Trans Type]","[Subscriptions].[Trans Type].&[ATT]","[Subscriptions].[Start Fiscal Year]","[Subscriptions].[Start Fiscal Year].&["&C2&"]","[Subscriptions].[Start Fiscal Week]","[Subscriptions].[Start Fiscal Week].&["&C1&".]")

    or perhaps:

    =GETPIVOTDATA("[Measures].[MP Count]",'[3Data.xlsx]ATT ENT'!$A$4,"[Subscriptions].[Attend Type]","[Subscriptions].[Attend Type].&[3MONTH]","[Subscriptions].[Trans Type]","[Subscriptions].[Trans Type].&[ATT]","[Subscriptions].[Start Fiscal Year]","[Subscriptions].[Start Fiscal Year].&["&SUBSTITUTE(TEXT(C2,"0.000E+00"),"+","")&"]","[Subscriptions].[Start Fiscal Week]","[Subscriptions].[Start Fiscal Week].&["&C1&".]")

  5. #5
    Board Regular
    Join Date
    Apr 2008
    Posts
    102
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Getpivotdata

    Sadly not, but I appreciate you trying for me.

  6. #6
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,990
    Post Thanks / Like
    Mentioned
    53 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Getpivotdata

    Can you post a workbook somewhere for testing?

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
  •