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.

3 comments:

  1. This concept is a good way to enhance the knowledge.thanks for sharing. please keep it up core Java online training

    ReplyDelete
  2. This concept is a good way to enhance the knowledge.thanks for sharing. please keep it up core Java online training

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete