.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotLayout.HideAllSubtotals() Method

Hides all subtotals in the PivotTable report.

Namespace: DevExpress.Spreadsheet

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

Declaration

void HideAllSubtotals()
Sub HideAllSubtotals

Remarks

Use the HideAllSubtotals method to remove subtotals for all outer row and column fields in a PivotTable report.

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")
' Hide subtotals at the top of each group.
pivotTable.Layout.HideAllSubtotals()

To remove subtotals for a particular outer field, call the field's PivotField.SetSubtotal method and pass the PivotSubtotalFunctions.None value to it.

See Also