Region Product Store Sales

East Jackets Sears $ $1,588,860$

West Gloves GAP $ $1,340,580$

South Sweaters Guess $ $1,702,350$

North Snow Pants Walmart $ $1,018,305$

East Gloves Guess $ $1,197,950$

West Sweaters Sears $ $472,900$

South Snow Pants Walmart $ $1,588,860$

North Jackets GAP $ $1,340,580$

Create a Pivot table for the above data by placing:

i$.$ Region in Report Filter area

ii$.$ Product in Column Label area

iii. Store in Row Label area

iv$.$ Sales in Values area

Apply the following filters to the Pivot Table:

i$.$ Region $-$South

ii$.$ Store$-$ Guess

$2.$ For the same data create a Bar Pivot Chart of the same data new spreadsheet by placing: Marks $\_\_\_\_\_\_\_/5$

i$.$ Region in Report Filter area

ii$.$ Product in Axis Fields area

iii. Store in Legend Fields area

iv$.$ Sales in Values area

Apply the following filters to the Pivot Chart:

i$.$ Region $$West