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

Declaration

[DefaultValue(false)]
public bool ShowTotalsForSingleValues { get; set; }
<DefaultValue(False)>
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.

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:

ShowTotalsForSingleValues_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:

ShowTotalsForSingleValues_True

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

See Also