Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getpivotdata custom subtotal cell reference
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,"Pr ocess 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getpivotdata custom subtotal cell reference
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getpivotdata custom subtotal cell reference
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" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getpivotdata custom subtotal cell reference
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getpivotdata custom subtotal | Excel Worksheet Functions | |||
getpivotdata custom subtotal | Excel Worksheet Functions | |||
Can getpivotdata use a cell reference? | Excel Worksheet Functions | |||
GETPIVOTDATA - HOW TO USE CELL REFERENCE? | New Users to Excel | |||
Lookup ADDRESS of GETPIVOTDATA Subtotal/Cell | Excel Worksheet Functions |