Learning Goal: I’m working on a excel case study and need the explanation and answer to help me learn.
Download the following Excel file.
Then
Summarize each county’s cumulative sales during the four-month period:
a. Using PivotTable, calculate the cumulative sales for each county during the four-month period.
b. Using PivotChart, create a bar chart that shows each county’s cumulative sales during the four-month period.