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).