G
Guest
I have a pivot table with dates as columns (11/1/2005, 2/1/2005,
3/1/2005...), three fields as rows and three data fields, including
"ORDERS_DOLLARS". When I use the GETPIVOTDATA in Excel 2000 to return the
sums for each month, some months work and others return "#N/A."
Here is a formula that works:
=GETPIVOTDATA(Sheet1!$A$5, "ORDERS_DOLLARS 11/1/2005")
Here is a formula that returns "#N/A"
=GETPIVOTDATA(Sheet1!$A$5, "ORDERS_DOLLARS 7/1/2005")
I can see that the pivot table has data for 7/1/2005 and 11/1/2005.
Does anyone have any ideas on why both formulas are not working?
Thanks.
3/1/2005...), three fields as rows and three data fields, including
"ORDERS_DOLLARS". When I use the GETPIVOTDATA in Excel 2000 to return the
sums for each month, some months work and others return "#N/A."
Here is a formula that works:
=GETPIVOTDATA(Sheet1!$A$5, "ORDERS_DOLLARS 11/1/2005")
Here is a formula that returns "#N/A"
=GETPIVOTDATA(Sheet1!$A$5, "ORDERS_DOLLARS 7/1/2005")
I can see that the pivot table has data for 7/1/2005 and 11/1/2005.
Does anyone have any ideas on why both formulas are not working?
Thanks.