---
schema_version: "1"
id: 37a60b39e4fa19d058223243261cdf0e997f89ae88b225c2ab92003f32decdd1
title: Perfect Pivoting
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/pro/desktop/buildmanual_multidimensional_perfectpivot.md
canonical_url: https://help.tableau.com/current/pro/desktop/en-gb/buildmanual_multidimensional_perfectpivot.htm
source_site: help.tableau.com
content_type: documentation
content_hash: ab3f4b3b25797bba8a38558c4591f7d2db01fde1fd213fffac24d4fe30446ea7
description: Understand perfect pivoting to work with cube hierarchy levels across worksheet shelves.
---
[Skip to main content](#main-content)

# Perfect Pivoting

**Note**: The following applies only to certain multidimensional data sources.

In Tableau, perfect pivoting refers to working with hierarchies in these ways:

- Using varying levels of detail including skipping levels (for example, Country and City, but not State).
- Using varying levels of detail on different worksheet shelves simultaneously (for example, Product Family on the Columns shelf and Product Department on Colour).
- Using varying levels of detail out of order (for example, Quarter before Year).

For example, in the following view the Market hierarchy is broken up to show the State level as Rows and the Region level as Colour.

![A chart that displays profit by state and product, segmented by market.](/tableau/current/en-gb/pro/desktop/en-gb/Img/pivot1.png)