Skip to main content
Row

PivotLayout.ShowAllSubtotals(Boolean) Method

Displays all subtotals in the PivotTable report.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

void ShowAllSubtotals(
    bool topOfGroup
)

Parameters

Name Type Description
topOfGroup Boolean

true, to display subtotals for the outer row fields on top; otherwise, false.

Remarks

By default, when you create a pivot table that contains multiple row and column fields, subtotals automatically appear for the outer fields. However, if subtotals have been turned off for the entire pivot table or its separate fields, you can display them again by using the ShowAllSubtotals method. The boolean parameter of this method allows you to specify the subtotal location for the outer row fields in compact or outline form: in particular, you can select whether to display subtotals at the top or bottom of each item in an outer row field. For row fields in tabular form, subtotals are always shown at the bottom.

SpreadsheetPivotTable_Subtotals

If you wish to use a different function to calculate subtotals or to display more than one type of subtotals for a particular pivot field, use the field’s PivotField.SetSubtotal method.

To remove all subtotals from the report, use the PivotLayout.HideAllSubtotals method.

Example

View Example

Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet

' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
' Show all subtotals at the top of each group.
pivotTable.Layout.ShowAllSubtotals(True)

The following code snippets (auto-collected from DevExpress Examples) contain references to the ShowAllSubtotals(Boolean) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also