PivotGridField.TotalsVisibility Property
Gets or sets whether totals are displayed for the current field when it is positioned within the Column Header Area or Row Header Area and if so, whether they are automatic or custom. This is a dependency property.
Namespace: DevExpress.Xpf.PivotGrid
Assembly: DevExpress.Xpf.PivotGrid.v14.2.dll
#Declaration
[XtraSerializableProperty]
[XtraSerializablePropertyId(3)]
public FieldTotalsVisibility TotalsVisibility { get; set; }#Property Value
| Type | Description |
|---|---|
| Field |
A Field |
#Remarks
The DXPivotGrid control lets you calculate automatic or custom totals against data fields. These totals are displayed as an additional column(s) for each value of an outer column field and as an additional row for each value of an outer row field.
For each data field a single automatic total is calculated, and its summary function is determined by the field's PivotGridField.SummaryType property. The number of automatic totals displayed for each value of an outer field matches the number of data fields.
Custom totals allow you to calculate multiple totals against each data field. A custom total is represented by the PivotGridCustomTotal class and its PivotGridCustomTotal.SummaryType property identifies the summary function type used to calculate the total.
To display custom totals instead of the automatic totals for the values of an outer column or row field, you should do the following:
- set the field's TotalsVisibility property to FieldTotalsVisibility.CustomTotals;
- add the PivotGridCustomTotal objects, which represent the custom totals, to the field's PivotGridField.CustomTotals collection.
If the TotalsVisibility property of an outer column or row field is set to FieldTotalsVisibility.None neither an automatic nor custom total is displayed for the values of this field.
NOTE
The row fields' Totals