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