getpivotdata custom subtotal
 

Hi all, hope somebody can help
I'm trying to get some data out of a pivot table
When using automatic subtotals I was able to use this formula-
=GETPIVOTDATA("assessment2",$B$15,"Trainee",D2,"Pr ocess
Skill",C2,"Level",B2) where cell values are as follows: B2 - 2, C2 - Test1,
D2 - a

When I changed the subtotals to 'min' I got a #ref error. I used the formula
below to get the data from a specific cell.
=GETPIVOTDATA($B$15,"Trainee[a] 'Test1' Level['2';Min]")
(where the 'Process Skill' is 'Test1')

Is it possible to modify this formula to use relative cell references (as
for B2, C2 and D2 above)?

Thanks