vcl-cxcustompivotgrid-dot-tcxpivotgridfield-466d0161.md
Specifies the type of the totals calculated and displayed within the pivot grid for the current field.
property TotalsVisibility: TcxPivotGridTotalsVisibility read; write; default tvAutomatic;
| Type | Default |
|---|---|
| TcxPivotGridTotalsVisibility | tvAutomatic |
The ExpressPivotGrid allows you to calculate and display totals (also called subtotals) only for column fields and row fields. There are two types of totals that can be calculated for these fields: automatic totals and custom totals. Automatic totals are calculated using a summary function which is specified by the corresponding data field via the SummaryType property. Custom totals can be calculated using any summary function (see the field’s SummaryType property). You can calculate multiple custom totals for a data field.
All the possible values for the TotalsVisibility property are listed in the following table.
| Value | Meaning |
|---|---|
| tvAutomatic | Automatic totals are calculated. |
| tvCustom | Custom totals are calculated. Use the field’s CustomTotals collection to specify custom totals and the summary functions that will be used to calculate them. |
| tvNone | Totals are not calculated for the current field. |
The default value of the TotalsVisibility property is tvAutomatic.
See Also