ExcelBanter - Get "avg" in pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Get "avg" in pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/152753-get-avg-pivot-table.html)

mazalam

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?

Jim Thomlinson

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?

All times are GMT +1. The time now is 02:37 AM.