Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I setup a custom subtotal? | Excel Worksheet Functions | |||
% of subtotal custom calculation in a pivot table | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Lookup ADDRESS of GETPIVOTDATA Subtotal/Cell | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |