![](https://cdn-0.access-excel.tips/wp-content/uploads/2014/12/feature_excel_vba-150x150.jpg)
Change Pivot Table Layout, why?
To illustrate why we want to change Pivot Table Layout, lets see the below example.
Assume that we use the following data to create a Pivot Table. We want to show the total summary, group by Department, Empl ID.
Excel 2003 - Tabular layout
Pivot Table layout is called "Tabular", where each grouping is in one column, and the subtotal is at the bottom of each group.
Excel 2007 and onwards - Compact layout
By default, Pivot Table layout is called ...
Read More