creating a memo from a pivot table

creating a memo from a pivot table

Your task is to write a 2 page Memo Report on the group you are assigned to from the “Product Material PivotTable” tab you created from Module 5 Project Assignment.

Steps:
1. From the Material filter to your assigned group on Canvas (Gold, Silver or Copper).
2. From the Type filter select “Select All”.

The Memo Report should contain information / analysis about the data you are viewing, which attributes were used, and what do the results indicate.

PivotTable:
Material
Type
Total Sales
Grand Total

PivotChart:
Column Chart
Filter by Material Type
Legend by years

Memo Report Length: 2 Pages double spaced

Ensure that you embed your unique copy of the PivotTable and PivotChart in your Memo Report from the worksheet. Then submit the Memo Report to Canvas. You may download a memo template from Microsoft Word in order to complete this assignment.