Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get "avg" in pivot table
Hi,
I have a spreadsheet with order #s, Order Date, Delivery Date, Delivery Days and Province columns. Using the pivot table, I want to see the avg delivery days by province. How can I achive this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get "avg" in pivot table
Place the province in the left hand column and the Deleivery days in the
center. Right Click on the delivery days and change the aggregation from Sum to Average... -- HTH... Jim Thomlinson "mazalam" wrote: Hi, I have a spreadsheet with order #s, Order Date, Delivery Date, Delivery Days and Province columns. Using the pivot table, I want to see the avg delivery days by province. How can I achive this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create pivot table, error "Range is not valid" | Charts and Charting in Excel | |||
How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
"Show Field List" in Pivot Table Toolbar doesn't work | Excel Discussion (Misc queries) | |||
Pivot Table "Include hidden items in totals" | Excel Discussion (Misc queries) |