Using the data in the file, create a pivot table that calculates the average of the sales that meet all of the following transactions:Sales amount from each transaction is between $300 and $1500.

Using the data in the file, create a pivot table that calculates the average of the sales that meet all of the following transactions:

(a) Sales amount from each transaction is between $300 and $1500,
(b) neither golf sales nor golf lessons nor restaurant in business line, and
(c) Ordered between May 2008 and October 2009, and