CubeField.LayoutSubtotalLocation Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Returns or sets the position of the PivotTable field subtotals in relation to (either above or below) the specified field.
public:
property Microsoft::Office::Interop::Excel::XlSubtototalLocationType LayoutSubtotalLocation { Microsoft::Office::Interop::Excel::XlSubtototalLocationType get(); void set(Microsoft::Office::Interop::Excel::XlSubtototalLocationType value); };public Microsoft.Office.Interop.Excel.XlSubtototalLocationType LayoutSubtotalLocation { get; set; }Public Property LayoutSubtotalLocation As XlSubtototalLocationTypeProperty Value
Remarks
XlSubtototalLocationType can be one of these XlSubtototalLocationType constants:
xlAtTop
xlAtBottom Default
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. For non-OLAP data sources, the value of this property doesn’t change when the field is rearranged or when it is added to or removed from the report.
The LayoutForm property determines whether the report appears in table format or in outline format.