getpivotdata custom subtotal

A

anna_717717

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,"Process
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

getpivotdata custom subtotal 5
getpivotdata custom subtotal cell reference 3
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Avoiding auxiliary cells 0
Copying formulas across columns 2
Formatting a spreadsheet to calculate difference in dates etc. 2
Pivot Table GETPIVOTDATA 2
Pivot Table with Data Model Connection - getpivotdata #REF error 0

Top