+ Reply to Thread
Results 1 to 4 of 4

GETPIVOTDATA Problem (Data Model)

  1. #1
    Registered User
    Join Date
    11-14-2014
    Location
    Estonia
    MS-Off Ver
    2013 Office for Mac
    Posts
    31

    GETPIVOTDATA Problem (Data Model)

    Hi everyone!

    I am used to pulling data from the pivot data with the GETPIVOTDATA formula, and changing the references in the formula, so it would be dynamic, but with the Data Model pivot, the GETPIVOTDATA formula is WAAAAAAY different:

    =GETPIVOTDATA("[Measures].[Distinct Count of Response ID]",$S$7,"[numeric_data].[Job Level]","[numeric_data].[Job Level].&[Consultant]")

    The question is, how do I make the "Consultant" to pull data e.g. from cell "C9"? It does not seem to work if I did it like this:

    =GETPIVOTDATA("[Measures].[Distinct Count of Response ID]",$S$7,"[numeric_data].[Job Level]","[numeric_data].[Job Level].&C9")


    Thanks a lot!

    Regards,

    Troi
    Last edited by troilii; 01-12-2016 at 06:03 PM.

  2. #2
    Registered User
    Join Date
    11-14-2014
    Location
    Estonia
    MS-Off Ver
    2013 Office for Mac
    Posts
    31

    Re: GETPIVOTDATA Problem (Data Model)

    Solved the problem!

    Right way:

    =GETPIVOTDATA("[Measures].[Distinct Count of Response ID]",$S$7,"[numeric_data].[Job Level]","[numeric_data].[Job Level].&["&C9&"]")

  3. #3
    Registered User
    Join Date
    05-03-2018
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    4

    Re: GETPIVOTDATA Problem (Data Model)

    Quote Originally Posted by troilii View Post
    Solved the problem!

    Right way:

    =GETPIVOTDATA("[Measures].[Distinct Count of Response ID]",$S$7,"[numeric_data].[Job Level]","[numeric_data].[Job Level].&["&C9&"]")
    Thank you very much, I spent hours looking for a solution. This worked perfectly.

  4. #4
    Registered User
    Join Date
    05-03-2018
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    4

    Re: GETPIVOTDATA Problem (Data Model)

    Thank you very much, I spent hours looking for a solution. This worked perfectly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1