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

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 0 February 10th 09 09:41 PM
How do I setup a custom subtotal? AndrewEdmunds Excel Worksheet Functions 0 October 17th 08 06:49 PM
% of subtotal custom calculation in a pivot table Diego Excel Discussion (Misc queries) 2 January 31st 07 05:50 PM
pasting to subtotal lines without replacing hidden -non-subtotal l harleydiva67 Excel Discussion (Misc queries) 1 October 12th 06 06:02 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 08:32 PM.

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

About Us

"It's about Microsoft Excel"