---
schema_version: "1"
id: c0c1af207e2fc220011f20a205a59b99a470169f5cfc8c55d73b608163f087c9
title: Perfect Pivoting
collection: tableau
version: current
locale: en-us
portal_url: https://docs.salesforce.com/tableau/current/en-us/pro/desktop/buildmanual_multidimensional_perfectpivot.md
canonical_url: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_multidimensional_perfectpivot.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 313fca8876f372c6c32126e1c56d60592050f3802ee8a5ff40a0f48cbdab4a67
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 Color).
- 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 Color.

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