Back to Devexpress

Member Table: Totals and Grand Totals

aspnet-7306-components-pivot-grid-member-tables-data-related-features-member-table-totals-and-grand-totals.md

latest2.8 KB
Original Source

Member Table: Totals and Grand Totals

  • Dec 17, 2020
MethodDescription
PivotGridOptionsViewBase.ColumnTotalsLocationSpecifies the location of column totals and grand totals.
PivotGridOptionsViewBase.RowTotalsLocationSpecifies the location of row totals and grand totals.
PivotGridOptionsViewBase.ShowColumnTotalsSpecifies whether column automatic totals are displayed.
PivotGridOptionsViewBase.ShowRowTotalsSpecifies whether row automatic totals are displayed.
PivotGridOptionsViewBase.ShowColumnGrandTotalsSpecifies whether column grand totals are displayed.
PivotGridOptionsViewBase.ShowRowGrandTotalsSpecifies whether row grand totals are displayed.
PivotGridOptionsViewBase.ShowTotalsForSingleValuesSpecifies whether automatic totals are displayed for the field values which contain a single nesting field value (or do not contain nesting field values).
PivotGridOptionsViewBase.ShowGrandTotalsForSingleValuesSpecifies whether grand totals are displayed when the control lists a single value of an outer column field or row field along its left or top edge.
PivotGridFieldBase.SummaryTypeSpecifies the type of summary function which is calculated against a data field. This also determines the type of summary function used to calculate automatic totals and grand totals.
PivotGridFieldBase.TotalsVisibilitySpecifies whether totals are displayed for a specific column or row field and if so, whether they are Automatic or Custom.
PivotGridField.CustomTotalsProvides access to the collection of custom totals for a specific column or row field.