Given below is a pivot table showing the relationship between primary, secondary and tertiary institutions employees in Fiji and 4 newspapers they read daily. To get the percentage as shown in the table, these steps are taken. Count of Reader Column Labels Row Labels 1 2 3 4 Grand Total 1 7.63% 5.08% 10.73% 10.45% 33.90% 2 8.19% 12.15% 5.93% 4.24% 30.51% 3 9.32% 14.41% 6.21% 5.65% 35.59% Grand Total 25.14% 31.64% 22.88% 20.34% 100.00% a. Click Count of Reader (in the PivotTable Fields), chose value field settings, chose ‘show value as’ option, highlight ‘% of Grand Total’. b. Click Occupation of Reader (in the PivotTable Fields), chose value field settings, chose ‘show value as’ option, highlight ‘% of Grand Total’. c. Click Newspaper, Occupation and Count of Reader (in the PivotTable Fields), chose value field settings, chose ‘show value as’ option, highlight ‘% of Grand Total’. d. Click Newspaper Reader (in the PivotTable Fields), chose value field settings, chose ‘show value as’ option, highlight ‘% of Grand Total’.
Answer: Creating a Pivot Table to Show Relationship Between Primary, Secondary and Tertiary Institutions Employees in Fiji and 4 Newspapers they Read Daily Creating a pivot table to show the relationship between primary, secondary and tertiary institutions employees in Fiji