Excel.PivotLayoutType enum
Remarks
Fields
compact = "Compact" | A horizontally compressed form with labels from the next field in the same column. |
outline = "Outline" | Inner fields' items are on same row as outer fields' items and subtotals are always on the bottom. |
tabular = "Tabular" | Inner fields' items are always on a new line relative to the outer fields' items. |
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins