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?