Question: Use the data in the Question 2 & 3 tab to create a pivot table according to the following criteria: 1 . Create your
Use the data in the "Question & tab to create a pivot table according to the following criteria:
Create your pivot table on a new worksheet, and name this worksheet "Answer Pivot table". This worksheet should appear next to the "Answer Descriptive Statistics" tab you created to answer Question
Create a pivot table that displays the Sales by Country by month. Filter the pivot table for year Put the InvoiceMonth in the Column Labels, and the Country in the Row Labels.
Ensure your pivot table includes grand totals and shows the contribution by country to the sales total. Hint: use of column.
Format the sales amount to include values greater than a thousand and use the thousands separator.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
