---
schema_version: "1"
id: 64812c55aec2d998262e048282072ba5b341213ec14f16200daab2b64a381d73
title: Perfect Pivoting with Dates
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/pro/desktop/dates_perfectpivot.md
canonical_url: https://help.tableau.com/current/pro/desktop/en-gb/dates_perfectpivot.htm
source_site: help.tableau.com
content_type: documentation
content_hash: b7f79f11d8831f93a59a4a02444472e736cff2d61ef04343027fb2deb7d0556b
description: Perfect pivot dates by placing different date levels on separate shelves at once.
---
[Skip to main content](#main-content)

# 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 colour-encodes the marks by quarter.

![A line chart that displays sales by quarter from 2012 to 2015.](/tableau/current/en-gb/pro/desktop/en-gb/Img/dates_7.png)

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

![A line chart that shows sales by month and quarter from 2012 to 2015.](/tableau/current/en-gb/pro/desktop/en-gb/Img/dates_8.png)