Join Dennis Taylor for an in-depth discussion in this video Using date and time as metrics in a PivotTable, part of Excel Tips Weekly.
- 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.…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.