LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
getpivotdata custom subtotal anna_717717 Excel Worksheet Functions 5 February 11th 09 08:33 PM
getpivotdata custom subtotal anna_717717 Excel Worksheet Functions 0 February 10th 09 09:41 PM
Can getpivotdata use a cell reference? Bryon Scruggs Excel Worksheet Functions 5 December 15th 08 10:17 PM
GETPIVOTDATA - HOW TO USE CELL REFERENCE? SSJ New Users to Excel 5 March 28th 07 08:59 PM
Lookup ADDRESS of GETPIVOTDATA Subtotal/Cell X Excel Worksheet Functions 0 August 19th 05 07:06 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"