Create a PivotTable.
Click the Past&Projected sheet tab.
Select cells A4:E60.
Click the Quick Analysis tool and choose Tables.
Point to each PivotTable option to see the Live Preview.
Choose the option that shows a sum of the employees, the total hours, and the patients by image (Figure 4-98).Figure 4-98 Suggested PivotTable choices from the Quick Analysis tool
Rename the sheet PivotTable.
Drag the Month field in the Rows area in the PivotTable Fields pane out of the pane and into the worksheet to remove the field from the PivotTable.