Returns or sets a Long value that represents the number of pixels that the data in the detail area is offset to the left. Use this property to move the data in the detail area to the left. Read/write.
expression.DetailLeftOffset
expression Required. An expression that returns a PivotColumnMember object.
Setting this property to a negative value will result in a run-time error.
This example moves the data in the detail area of PivotTable1 10 pixels to the left.
PivotTable1.ActiveData.ColumnAxis.ColumnMember.DetailLeftOffset = 10