Our PivotTable is now complete. However, there are some things we can do to make it easier to understand. We will rename, rearrange, and move labels to change the view of the PivotTable.
The Lunches field labels appear simply as "no" and "yes." We want to make these label titles more obvious and descriptive. We will rename them.
Step1. To rename the "no" label,
Click in cell A4, type: No Lunch Enter
Step2. To rename the "yes" label,
Click in cell A25, type: Lunch Enter
Step3. To rename the Sum of Rx label,
Click in cell B3, type: Total Rx Enter
Rearranging Row Labels in a PivotTable
Our PivotTable is becoming easier to understand; however, we would like to display the Lunch field before the No Lunch field. We've already seen how to rearrange labels by using the drop-down contextual menu. This time we will rearrange by dragging and dropping the label.
Step1. To select the Lunch label,
Click in cell A25
Step2. Place the cursor on the edge of cell A25 until you see the Move cursor.
NOTE for MacOS Users: The Move cursor is a gloved hand.
Step3. To move the Lunch label,
Press & Drag cell A25 between rows 3 and 4
Moving a Field to the Columns Area
The PivotTable shows us how many prescriptions the doctors wrote after visits which included lunch versus visits without lunch. While this layout gives us a good idea of the big picture, we may want to compare each individual doctor's prescription writing habits. To do this, we can move one of the row fields to the columns area. This will shift the view of the PivotTable.
Step1. To move the Lunches field to the Columns area, from the Rows area,
Press & Drag Lunches to the Columns area
Step2. To save the workbook, press: