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
Bookmarks