Create PivotTables using Filter(s) and Slicer functions following the instructions in Handout_Data Summarization (Advanced). Submit one Excel file that includes all PivotTables
The Excel file submitted should include:
PivotTable on page 1
With the filter tab (Genres_single) above the table
PivotTable in 1.2.5.c in page 7
Top 10 distributors based on International
The table must be sorted in descending order by International.
PivotTable in 1.2.6.c in page 10
The table returns only movies with domestic sales exceeding $100 million.
PivotTable in page 15
MPA ratings should be sorted out.
Have two slicers of Year and MPA.
PivotTables in page 19
Have two slicers of Year and MPA.
Have the columns for Total Sales, Budget, Profit, and Profit Margin.
Profit and Profit Margin should be created with “Calculated Fields”.
PivotTables in page 25
Have three slicers of MPA, Animation, and Year.
These slicers should be connected with both PivotTables.Analysis of PivotTables with the Filter(s) and/or Slicer functions.
Please select one of the three tables you have developed in WA3
Add at least two fields or variables to the selected PivotTable
One of the fields added to the PivotTable should be one of the critic rating fields: TomatoCritic or AudienceCritic
Describe why you add these fields or variables to the PivotTable
At least two slicers should be used in your analysis
Identify and describe two new findings from the updated PivotTable in detail
