LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarkM
 
Posts: n/a
Default getpivotdata function

In Excel 2000, can I have more than one data field in my pivot table and
still use the GETPIVOTDATA function?

My pivot table is laid out as such:
Date
DesShop Pathway Data 200501 200502
240 Database Sum of DeliveryQty 12 14
Sum of DeliveryAmt 15853 15652
Retail Sum of DeliveryQty 3 4
Sum of DeliveryAmt 2997 7888
Grassroots Sum of DeliveryQty 0
Sum of DeliveryAmt 0
Managed Care Sum of DeliveryQty 1
Sum of DeliveryAmt 1995
240 St. Peterburg Sum of DeliveryQty 16 18
240 St. Peterburg Sum of DeliveryAmt 20845 23540

If I only have the Sum of DeliveryAmt data field in my table the
GETPIVOTDATA function works. But I cannot figure out how to get it to work
with both data fields on my table. I have tried changing the Pivot_table to
reference the cell number (C8) and also tried to enter in the data field name
(Sum of DeliveryAmt) but can not get it to work.

Thanks in advance.

 
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
create pivot table formula without the GETPIVOTDATA function ebergkes Excel Discussion (Misc queries) 3 November 11th 05 12:25 AM
Changing worksheet cells from within a function James4U2enjoy Setting up and Configuration of Excel 1 October 14th 05 02:16 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 05:08 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"