Get "avg" in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Them delivery services - some good, some not so good 3
Open the world of Pivot Tables 1
conditional pivot table??? 1
pivot table maybe?? combining information 2
Amazon are rubbish 14
Choosing a date from a list based on two criteria 2
VBAscript for data matching excels 0
Conditional format to change row colour 1

Back
Top