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