It’s easy to display details in a PivotTable group if you know how to expand the group in Microsoft Excel.

To insert an Excel PivotTable that will display hourly call counts, do the following: Click anywhere inside the data range or Table object. Click the Insert tab. Choose PivotTable from the Tables ...

If you had previously clicked within your data, the entire range should already be selected in the Table/Range area in the Create PivotTable window, as shown in the red circle in the screenshot below.