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.v18.2.Core.dll

Declaration

C#

[DefaultValue(false)]
[XtraSerializableProperty]
[TypeConverter(typeof(BooleanTypeConverter))]
public bool ShowCustomTotalsForSingleValues { get; set; }

VB.NET

<DefaultValue(False)>
<XtraSerializableProperty>
<TypeConverter(GetType(BooleanTypeConverter))>
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.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to ShowCustomTotalsForSingleValues
WinForms Controls	PivotGridControl	.OptionsView.ShowCustomTotalsForSingleValues
ASP.NET Controls and MVC Extensions	ASPxPivotGrid	.OptionsView.ShowCustomTotalsForSingleValues
	MVCxPivotGrid	.OptionsView.ShowCustomTotalsForSingleValues
	PivotGridSettings	.OptionsView.ShowCustomTotalsForSingleValues
Reporting	XRPivotGrid	.OptionsView.ShowCustomTotalsForSingleValues

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: