software

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
DesShopPathwayData 200501200502
240 Database Sum of DeliveryQty1214
Sum of DeliveryAmt1585315652
Retail Sum of DeliveryQty34
Sum of DeliveryAmt29977888
Grassroots Sum of DeliveryQty0
Sum of DeliveryAmt0
Managed Care Sum of DeliveryQty1
Sum of DeliveryAmt1995
240 St. Peterburg Sum of DeliveryQty 1618
240 St. Peterburg Sum of DeliveryAmt 2084523540

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.What version of Excel are you using?
What's the formula that works when you hae only one data field?

MarkM wrote:
gt; In Excel 2000, can I have more than one data field in my pivot table and
gt; still use the GETPIVOTDATA function?
gt;
gt; My pivot table is laid out as such:
gt; Date
gt; DesShopPathwayData 200501200502
gt; 240 Database Sum of DeliveryQty1214
gt; Sum of DeliveryAmt1585315652
gt; Retail Sum of DeliveryQty34
gt; Sum of DeliveryAmt29977888
gt; Grassroots Sum of DeliveryQty0
gt; Sum of DeliveryAmt0
gt; Managed Care Sum of DeliveryQty1
gt; Sum of DeliveryAmt1995
gt; 240 St. Peterburg Sum of DeliveryQty 1618
gt; 240 St. Peterburg Sum of DeliveryAmt 2084523540
gt;
gt; If I only have the Sum of DeliveryAmt data field in my table the
gt; GETPIVOTDATA function works. But I cannot figure out how to get it to work
gt; with both data fields on my table. I have tried changing the Pivot_table to
gt; reference the cell number (C8) and also tried to enter in the data field name
gt; (Sum of DeliveryAmt) but can not get it to work.
gt;
gt; Thanks in advance.
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlI am in Excel 2000.

If I have my table set up with only one data field (DeliveryAmt) the
GETPIVOTDATA formula =GETPIVOTDATA(A5,quot;240 St. Peterburg Database 200501quot;)
works, it gets 15853.

Sum of DeliveryAmt Date
DesShop Pathway 200501
240 St. PeterburgDatabase 15853
Retail 2997
Grassroots 0
Managed Care 1995
240 St. Peterburg Total 20845

Cell A5 has the data field Sum of DeliveryAmt. When I add another data
field, sum of DeliveryQty it then puts the two data fields in column C and A5
is blank, see example from original post. I change A5 to C8, which is the
cell that the DeliveryAmt is located in but the formula does not work, I get
a #REF message. I have tried entering the field name DeliveryAmt, Sum of
DeliveryAmt and get a #NAME message.

Thanks for helping with this.quot;Debra Dalgleishquot; wrote:

gt; What version of Excel are you using?
gt; What's the formula that works when you hae only one data field?
gt;
gt; MarkM wrote:
gt; gt; In Excel 2000, can I have more than one data field in my pivot table and
gt; gt; still use the GETPIVOTDATA function?
gt; gt;
gt; gt; My pivot table is laid out as such:
gt; gt; Date
gt; gt; DesShopPathwayData 200501200502
gt; gt; 240 Database Sum of DeliveryQty1214
gt; gt; Sum of DeliveryAmt1585315652
gt; gt; Retail Sum of DeliveryQty34
gt; gt; Sum of DeliveryAmt29977888
gt; gt; Grassroots Sum of DeliveryQty0
gt; gt; Sum of DeliveryAmt0
gt; gt; Managed Care Sum of DeliveryQty1
gt; gt; Sum of DeliveryAmt1995
gt; gt; 240 St. Peterburg Sum of DeliveryQty 1618
gt; gt; 240 St. Peterburg Sum of DeliveryAmt 2084523540
gt; gt;
gt; gt; If I only have the Sum of DeliveryAmt data field in my table the
gt; gt; GETPIVOTDATA function works. But I cannot figure out how to get it to work
gt; gt; with both data fields on my table. I have tried changing the Pivot_table to
gt; gt; reference the cell number (C8) and also tried to enter in the data field name
gt; gt; (Sum of DeliveryAmt) but can not get it to work.
gt; gt;
gt; gt; Thanks in advance.
gt; gt;
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

Debra, Thanks for your help. I figurded out what I needed to do. I created
a named range for the entire pivot table and used that for the reference
field. I was also missing the Sum of DeliveryAmt in the name range. So my
function looks like this: =GETPIVOTDATA(PivotTable,quot;'240 St. Peterburg'
'Database' '200501' 'Sum of DeliveryAmt'quot;)quot;Debra Dalgleishquot; wrote:

gt; What version of Excel are you using?
gt; What's the formula that works when you hae only one data field?
gt;
gt; MarkM wrote:
gt; gt; In Excel 2000, can I have more than one data field in my pivot table and
gt; gt; still use the GETPIVOTDATA function?
gt; gt;
gt; gt; My pivot table is laid out as such:
gt; gt; Date
gt; gt; DesShopPathwayData 200501200502
gt; gt; 240 Database Sum of DeliveryQty1214
gt; gt; Sum of DeliveryAmt1585315652
gt; gt; Retail Sum of DeliveryQty34
gt; gt; Sum of DeliveryAmt29977888
gt; gt; Grassroots Sum of DeliveryQty0
gt; gt; Sum of DeliveryAmt0
gt; gt; Managed Care Sum of DeliveryQty1
gt; gt; Sum of DeliveryAmt1995
gt; gt; 240 St. Peterburg Sum of DeliveryQty 1618
gt; gt; 240 St. Peterburg Sum of DeliveryAmt 2084523540
gt; gt;
gt; gt; If I only have the Sum of DeliveryAmt data field in my table the
gt; gt; GETPIVOTDATA function works. But I cannot figure out how to get it to work
gt; gt; with both data fields on my table. I have tried changing the Pivot_table to
gt; gt; reference the cell number (C8) and also tried to enter in the data field name
gt; gt; (Sum of DeliveryAmt) but can not get it to work.
gt; gt;
gt; gt; Thanks in advance.
gt; gt;
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

Great! Thanks for posting your solution.

MarkM wrote:
gt; Debra, Thanks for your help. I figurded out what I needed to do. I created
gt; a named range for the entire pivot table and used that for the reference
gt; field. I was also missing the Sum of DeliveryAmt in the name range. So my
gt; function looks like this: =GETPIVOTDATA(PivotTable,quot;'240 St. Peterburg'
gt; 'Database' '200501' 'Sum of DeliveryAmt'quot;)
gt;
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt;
gt;gt;What version of Excel are you using?
gt;gt;What's the formula that works when you hae only one data field?
gt;gt;
gt;gt;MarkM wrote:
gt;gt;
gt;gt;gt;In Excel 2000, can I have more than one data field in my pivot table and
gt;gt;gt;still use the GETPIVOTDATA function?
gt;gt;gt;
gt;gt;gt;My pivot table is laid out as such:
gt;gt;gt; Date
gt;gt;gt;DesShopPathwayData 200501200502
gt;gt;gt;240 Database Sum of DeliveryQty1214
gt;gt;gt; Sum of DeliveryAmt1585315652
gt;gt;gt; Retail Sum of DeliveryQty34
gt;gt;gt; Sum of DeliveryAmt29977888
gt;gt;gt; Grassroots Sum of DeliveryQty0
gt;gt;gt; Sum of DeliveryAmt0
gt;gt;gt; Managed Care Sum of DeliveryQty1
gt;gt;gt; Sum of DeliveryAmt1995
gt;gt;gt;240 St. Peterburg Sum of DeliveryQty 1618
gt;gt;gt;240 St. Peterburg Sum of DeliveryAmt 2084523540
gt;gt;gt;
gt;gt;gt;If I only have the Sum of DeliveryAmt data field in my table the
gt;gt;gt;GETPIVOTDATA function works. But I cannot figure out how to get it to work
gt;gt;gt;with both data fields on my table. I have tried changing the Pivot_table to
gt;gt;gt;reference the cell number (C8) and also tried to enter in the data field name
gt;gt;gt;(Sum of DeliveryAmt) but can not get it to work.
gt;gt;gt;
gt;gt;gt;Thanks in advance.
gt;gt;gt;
gt;gt;
gt;gt;
gt;gt;--
gt;gt;Debra Dalgleish
gt;gt;Excel FAQ, Tips amp; Book List
gt;gt;www.contextures.com/tiptech.html
gt;gt;
gt;gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html