PivotTable.CompactRowIndent Property (Excel)
Returns or sets the indent increment for PivotItems when compact row layout form is turned on. Read/write.
Version Information
Version Added: Excel 2007
Syntax
expression .CompactRowIndent
expression A variable that represents a PivotTable object.
Remarks
The default value is 1. The valid values for this setting are 0 to the maximum indent specified in Microsoft Excel.