Excel – Mixed Pivot Table Layout
Microsoft Excel Pivot Tables is one of the greatest inventions known to man; second only to those buttery mints they bring you in fancy restaurants. Even the greatest of ideas are not without their issues. Take for example the Report Layout feature in Pivot Tables. Excel gives the user three options with which to display hierarchically (wow; that’s a hard word to spell) related data.
- Compact Form
- Outline Form
- Tabular Form
Let’s examine what makes each layout unique.
All row-based data is combined into a single column, one row per line item, and indented to reflect the position within the hierarchy.