Perfect Pivoting with Dates

You can perfect pivot dates by placing different date levels on different worksheet shelves simultaneously. Place the date field on a variety of shelves and then select the desired date level from the fields’ context menus.
For example, the following line chart displays years as column headers and then color-encodes the marks by quarter.

You can separate the marks by month and by quarter as shown below.

4 comments: