PivotGridOptionsViewBase.ShowCustomTotalsForSingleValues Property

Gets or sets whether custom totals are displayed for the field values which contain a single nesting field value.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

[DefaultValue(false)]
public bool ShowCustomTotalsForSingleValues { get; set; }
<DefaultValue(False)>
Public Property ShowCustomTotalsForSingleValues As Boolean

Property Value

Type Default Description
Boolean

false

true to display custom totals for any field value; false to display custom totals for the field values which fall into two or more categories.

Remarks

When the ShowCustomTotalsForSingleValues property is set to false custom totals are calculated and displayed against the field values which fall into two or more categories. If a field value doesn't contain or contains a single nesting field value the corresponding total is not displayed. The image below shows a sample XtraPivotGrid control with the ShowCustomTotalsForSingleValues property set to false:

ShowCustomTotalForSingleValue_False

In this image, the 'Argentina' field value contains a single nesting field value ('Buenos Aires'), so custom totals are not displayed. The 'Austria' field value falls into two categories ('Graz' and 'Salzburg'). Therefore the XtraPivotGrid control displays the custom totals for this field.

The following image shows the XtraPivotGrid control with the ShowCustomTotalsForSingleValues property set to true:

ShowCustomTotalForSingleValue_True

See Also