---
schema_version: "1"
id: b9599a818bac020a5f5a86ff5c3d6d11efdf7dde772fdde12e06a96ed6dd6d30
title: Perfect Pivoting
collection: tableau
version: next
locale: en-us
portal_url: https://docs.salesforce.com/tableau/next/en-us/pro/desktop/buildmanual_multidimensional_perfectpivot.md
canonical_url: https://help.tableau.com/v0.0/pro/desktop/en-us/buildmanual_multidimensional_perfectpivot.htm
source_site: help.tableau.com
content_type: documentation
content_hash: cbaf27dc41eee04c317006a1fd6cfaf7ae367b673fffaf9e89c6246669f5d1e0
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/next/en-us/pro/desktop/en-us/Img/pivot1.png)