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.v23.2.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
Declaration
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:
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:
