Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average from the GETPIVOTDATA formula
Hello,
I have a pivot table that calculates various data points by cost center, by year, by month. I want to use the GETPIVOTDATA formula to calculate the average for a particular data point. I am receiving a #REF error from the following formula: =GETPIVOTDATA("Sum of LTL lb/SW",Pivots!$A$10,"Fiscal Year","FY 2007","City","Atlanta","CDC Market","CDCATL"). Can I specify a particular range within the pivot table? How can I get this to work? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup within GetPivotData formula | Excel Worksheet Functions | |||
Help a Newbie! Using GETPIVOTDATA formula! | Excel Discussion (Misc queries) | |||
calculate average for all of data field using GETPIVOTDATA? | Excel Worksheet Functions | |||
GETPIVOTDATA FORMULA | Excel Worksheet Functions | |||
Is there any way to disable the "getpivotdata" automatic formula? | Excel Worksheet Functions |