Question: Pivot Table Exercise 1 Using the data on the right, create a pivot table Set the Pivot table to have the months in the rows

Pivot Table Exercise 1 Using the data on the right, create a pivot table Set the Pivot table to have the months in the rows and the years in the columns. The date in the table is the actual sales Put Years in the Columns Rows Months Sum of Actual Sales Add column of average monthly sales Create a pivot chart Add title X and Y Axis And the linear line and equation, for all lines Add average columns for months and years Questions 1 What is the grand total for March? 2 What is the Grand total for 20213 What is the Grand Total? 4 What is the intercept for the line for 20215 What is the slope for the line for 2022+6 Uploade your pivot chart

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!