PivotGridOptionsViewBase.ShowTotalsForSingleValues Property

Gets or sets whether automatic 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 ShowTotalsForSingleValues { get; set; }

VB.NET

<DefaultValue(False)>
<XtraSerializableProperty>
<TypeConverter(GetType(BooleanTypeConverter))>
Public Property ShowTotalsForSingleValues As Boolean

Property Value

Type	Default	Description
Boolean	**false**	true to display totals for any field value; false to display 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 ShowTotalsForSingleValues
WinForms Controls	PivotGridControl	.OptionsView.ShowTotalsForSingleValues
ASP.NET Controls and MVC Extensions	ASPxPivotGrid	.OptionsView.ShowTotalsForSingleValues
	MVCxPivotGrid	.OptionsView.ShowTotalsForSingleValues
	PivotGridSettings	.OptionsView.ShowTotalsForSingleValues
Reporting	XRPivotGrid	.OptionsView.ShowTotalsForSingleValues

Remarks

When the ShowTotalsForSingleValues property is set to false 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 following image shows a sample XtraPivotGrid control with the ShowTotalsForSingleValues property set to false:

In this image, the ‘Eastern Connection’ field value contains a single nesting field value (‘Camembert Pierrot’), so a corresponding row total is not displayed. The ‘Bottom Dollar Markets’ field value falls into two categories (‘Aniseed Syrup’ and ‘Camembert Pierrot’). Therefore the XtraPivotGrid control displays a row total for this field (‘Bottom-Dollar Markets Total’).

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

Now the row total for the ‘Eastern Connection’ field value is visible and it duplicates information from the preceding row.