Using date and time as metrics in a PivotTable

- One of the PivotTable's greatest strengths…is its ability to analyze information by date and time.…In this worksheet, here, we're showing sales data,…transaction data, over a two year period…and it's identified by the date in which it occured…and the time of day.…We might want to analyze the information…based on either or both of those criteria there.…Let's create a PivotTable on this worksheet.…We can go to the Insert tab on the ribbon.…Select PivotTable, choose Existing Worksheet,…click on the Location panel below it…and I'll simply click on cell H1 in the background,…click OK.…

The PivotTable Fields list, I'm going to shrink it a bit…and by the way, you can make this be docked…by simply double-clicking, if it's already docked,…and you'd like to move it out from the docking position,…simply grab its title bar and move it out.…I usually prefer have it undocked or floating.…Now, let's imagine this PivotTable we'd like to see,…at least initially, is a, say the date in which…a particular sale occurs, so I'll choose Date first.…