Perfect Pivoting

Applies to: Tableau Desktop

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.

Back to top
Thanks for your feedback!Your feedback has been successfully submitted. Thank you!