Rusty on Pivot Tables

I was given this problem on the attached sheet

As a single operation create a pivot table from the data below: Count the items, Sum together the values by location and establish the average quantities

I am way rusty, and would like to see the answer so I can figure it out

Any help appreciatedpivot problem.xlsx

No takers? Cmon! >:-)

385256d1427242019-rusty-on-pivot-tables-pivot-problem.xlsx See if page 2 is enough to refresh your memory.

thank you for the reply, and the sarcasm! I cannot open the link, and have contacted excel forum since Tuesday with no response. I look forward to seeing your results. Thanks again