In the PivotTable group (to the far left), click the Options dropdown (under the PivotTable Name box), and choose Options from the dropdown list. In the resulting dialog, click the Data tab.

5. In the resulting PivotTable Fields dialog box, check the boxes next to each field name (as pictured below) to populate the PivotTable with employee time data.. 6. The PivotTable will automatically ...

The easiest way to group is by a simple sort by the Call-In time values, but the problem with a sort is that it doesn’t count anything, and we want an hourly count. A PivotTable can group and ...