PivotTotalsVisibility Enum

Contains values that specify which summary totals are displayed for a specific column field or row field.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v17.2.Core.dll

Declaration

C#

[TypeConverter(typeof(EnumTypeConverter))]
[ResourceFinder(typeof(ResFinder), "PropertyNamesRes")]
public enum PivotTotalsVisibility

VB.NET

<TypeConverter(GetType(EnumTypeConverter))>
<ResourceFinder(GetType(ResFinder), "PropertyNamesRes")>
Public Enum PivotTotalsVisibility

Members

Name	Description
AutomaticTotals	Specifies that automatic totals are calculated.
CustomTotals	Specifies that custom totals are calculated using the formula in the PivotGridField.CustomTotals collection.
None	Specifies that a summary total is not calculated.

Related API Members

The following properties accept/return PivotTotalsVisibility values:

• PivotGridFieldBase.TotalsVisibility

Remarks

The PivotGridFieldBase.TotalsVisibility property of the PivotTotalsVisibility type specifies which summary totals are displayed for a specific column field or row field.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotTotalsVisibility enum.

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.

C#

winforms-pivot-totals-visibility/CS/Form1.cs#L40

private void CreateToggleTotalsItem(DevExpress.XtraPivotGrid.PopupMenuShowingEventArgs e) {
    bool isTotalsVisible = e.Field.TotalsVisibility != PivotTotalsVisibility.None;
    DXMenuItem toggleTotalItem = new DXMenuItem(isTotalsVisible ? "Hide Totals" : "Show Totals", ToggleTotalsMenuItemClick);

how-to-avoid-production-of-unnecessary-column-and-merging-of-cells-in-excel-export-e2346/CS/WindowsApplication53/Form1.cs#L57

fieldExportHeader.AreaIndex = 0;
fieldExportHeader.TotalsVisibility = PivotTotalsVisibility.None;
pivotGridControl1.OptionsView.ShowGrandTotalsForSingleValues = true;

how-to-calculate-multiple-custom-totals-with-summarytype-set-to-custom-e3815/CS/XtraPivotGrid_MultipleCustomTotals/Form1.cs#L53

    // Enables the Custom Totals to be displayed instead of Automatic Totals.
    fieldCategoryName.TotalsVisibility = PivotTotalsVisibility.CustomTotals;
}

how-to-calculate-multiple-custom-totals-with-summarytype-set-to-custom-e3821/CS/ASPxPivotGrid_MultipleCustomTotals/Default.aspx.cs#L44

    // Enables the Custom Totals to be displayed instead of Automatic Totals.
    fieldCategoryName.TotalsVisibility = PivotTotalsVisibility.CustomTotals;
}

VB.NET

winforms-pivot-totals-visibility/VB/Form1.vb#L47

Private Sub CreateToggleTotalsItem(ByVal e As DevExpress.XtraPivotGrid.PopupMenuShowingEventArgs)
    Dim isTotalsVisible As Boolean = e.Field.TotalsVisibility <> PivotTotalsVisibility.None
    Dim toggleTotalItem As New DXMenuItem(If(isTotalsVisible, "Hide Totals", "Show Totals"), AddressOf ToggleTotalsMenuItemClick)

how-to-avoid-production-of-unnecessary-column-and-merging-of-cells-in-excel-export-e2346/VB/WindowsApplication53/Form1.vb#L53

fieldExportHeader.AreaIndex = 0
fieldExportHeader.TotalsVisibility = PivotTotalsVisibility.None
pivotGridControl1.OptionsView.ShowGrandTotalsForSingleValues = True

how-to-calculate-multiple-custom-totals-with-summarytype-set-to-custom-e3815/VB/XtraPivotGrid_MultipleCustomTotals/Form1.vb#L54

    ' Enables the Custom Totals to be displayed instead of Automatic Totals.
    fieldCategoryName.TotalsVisibility = PivotTotalsVisibility.CustomTotals
End Sub

how-to-calculate-multiple-custom-totals-with-summarytype-set-to-custom-e3821/VB/ASPxPivotGrid_MultipleCustomTotals/Default.aspx.vb#L48

    ' Enables the Custom Totals to be displayed instead of Automatic Totals.
    fieldCategoryName.TotalsVisibility = PivotTotalsVisibility.CustomTotals
End Sub