Q4. pivot Table (5 points) 1. Define the pivot table. 2. what are the key components?...

Transcribed Image Text:

Q4. pivot Table (5 points) 1. Define the pivot table. 2. what are the key components? 3. By using the below table City Product Revenue Cost Riyadh Camera 10 Dammam Camera 15 Riyadh Laptop 9 Jeddah Television 5 Jeddah Camera 5 838032 Jeddah Laptop Riyadh Printer Riyadh Laptop Dammam Jeddah Printer Printer Riyadh Television Dammam Television Dammam Laptop Fill missing fields to display the table 1. 5333 53267555 1 1 1 4 FIELD NAME Q Search fields Camera Laptop Printer Television Grand Total Filters III Columns Dammam 3 3 4 3 3 Jeddah 2 1 5 3 1 Riyadh 8 1 1 3 1 Grand Rows Values 2 1 3 1 Total Table 1 Q4. pivot Table (5 points) 1. Define the pivot table. 2. what are the key components? 3. By using the below table City Product Revenue Cost Riyadh Camera 10 Dammam Camera 15 Riyadh Laptop 9 Jeddah Television 5 Jeddah Camera 5 838032 Jeddah Laptop Riyadh Printer Riyadh Laptop Dammam Jeddah Printer Printer Riyadh Television Dammam Television Dammam Laptop Fill missing fields to display the table 1. 5333 53267555 1 1 1 4 FIELD NAME Q Search fields Camera Laptop Printer Television Grand Total Filters III Columns Dammam 3 3 4 3 3 Jeddah 2 1 5 3 1 Riyadh 8 1 1 3 1 Grand Rows Values 2 1 3 1 Total Table 1