getpivotdata custom subtotal cell reference

[anna_717717]

Hi all, hope somebody can help me

I'm trying to get some data from a pivot table
When I was using automatic subtotals I was able to use the formula:
=GETPIVOTDATA("assessment2",$B$15,"Trainee",D2,"Process Skill",C2,"Level",B2)

When I changed to 'min' subtotals I got a #ref error and tried:
=GETPIVOTDATA($B$15,"Trainee[a] 'Test1' Level['2';Min]")
(where 'Test1' is a 'Process Skill')

Is it possible to modify this formula to include cell references (i.e. B2,
C2, and D2 as above)

Thanks

 

[Herbert Seidenberg]

Change the first argument from $B$15 to $B$15&""
See:
http://www.contextures.com
Excel -- Pivot Tables -- GetPivotData
Using Cell References For the Data Field in GetPivotData

 

[anna_717717]

Hi
I tried changing to:
=GETPIVOTDATA($B$15&"","Trainee['a'] 'Test1' Level['2';Min]")
but still get a #ref error even before trying to reference any cells! Any
thoughts on where I'm going wrong?

Thanks

 

[Herbert Seidenberg]

Need all the data, including source of PT.
Upload the desensitized file to one of them:
http://freefilehosting.net/
http://www.savefile.com/
http://www.mediafire.com/
and post the link.