LayoutSubtotalLocation Property

LayoutSubtotalLocation Property

         Example         Applies To

Returns or sets the position of the PivotTable field subtotals in relation to (either above or below) the specified field. Can be either of the following XlSubtotalLocationType constants: xlAtTop or xlAtBottom. The default value is xlAtBottom. Read/write Long.

Remarks

You can set this property for any PivotTable field in outline format; however, the formatting appears only if the specified field is a row field other than the innermost (lowest level) row field. The value of this property doesn’t change when the field is rearranged or when it is added to or from removed from the report.

The LayoutForm property determines whether the report appears in table format or in outline format.