Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create pivot table formula without the GETPIVOTDATA function | Excel Discussion (Misc queries) | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |