Download and open Adventure Work spreadsheet, which is available on BlazeView. Using this

spreadsheet, you need to create the following pivot table to answer the question: Find customers who

bought more than $$4000$ in $2009$ and give them a gift certificate, which is worth $5\%$ of the sum of sales

amount in $2009.$ Add a calculated field with the IF function to your pivot table. The name of new

calculated field should be $$Gift Certificate$1.$ Then, sort from the largest sum of gift certificate to the

smallest. A sample pivot table is below:

Please take a screenshot of your pivot table and paste it below $($You don$$t need to display all customers

in your screenshot$)$:

Question#$2(10$ points$)$

Download and open Adventure Work spreadsheet, which is available on BlazeView. Using this

spreadsheet, you need to create the following pivot table to answer the question: Find customers who

bought more than $$3000$ in Germany in $2010$ and give them a gift certificate, which is worth $5\%$ of the

sum of sales amount in Germany in $2010.$ Add a calculated field with the IF function to your pivot table.

The name of new calculated field should be $$Gift Certificate$2.$ Then, sort from the largest sum of gift

certificate to the smallest. A sample pivot table is below:

$1$