getpivotdata custom subtotal cell reference

  • Thread starter Thread starter anna_717717
  • Start date Start date
A

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
 
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
 
Back
Top