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 and 4 newspapers they read daily requires following steps:

Step 1: Count of Reader

In the PivotTable Fields, click Count of Reader. In the Value Field Settings, choose the ‘Show Value As’ option and highlight ‘% of Grand Total’.

Step 2: Occupation of Reader

In the PivotTable Fields, click Occupation of Reader. In the Value Field Settings, choose the ‘Show Value As’ option and highlight ‘% of Grand Total’.

Step 3: Newspaper, Occupation and Count of Reader

In the PivotTable Fields, click Newspaper, Occupation and Count of Reader. In the Value Field Settings, choose the ‘Show Value As’ option and highlight ‘% of Grand Total’.

Step 4: Newspaper Reader

In the PivotTable Fields, click Newspaper Reader. In the Value Field Settings, choose the ‘Show Value As’ option and highlight ‘% of Grand Total’.

Related Questions:

• What is a pivot table?
• What are the uses of a pivot table?
• How do I create a pivot table in Excel?
• What is the purpose of the Grand Total in a pivot table?
• How do I use the Value Field Settings in a pivot table?
• What are the different types of pivot tables?
• What are the advantages of using a pivot table?
• What is the difference between a pivot table and a query table?
• How do I add a column to a pivot table?
• What is the purpose of the ‘Show Value As’ option in a pivot table?