---
schema_version: "1"
id: 645e19261924a81b8639412c1de5177b50284df5189822718eafb8242918aea3
title: Perfect Pivoting with Dates
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/public/desktop/dates_perfectpivot.md
canonical_url: https://help.tableau.com/v0.0/public/desktop/en-gb/dates_perfectpivot.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 7b5496961b2d38110fa8cbc9fd8fedc374a0d6d8a9e948b1c991d7f8446c6b3f
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/next/en-gb/public/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/next/en-gb/public/desktop/en-gb/Img/dates_8.png)