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