Defines the summary operation by which the current custom total is calculated.
Remarks
Property specifies the summary operations used to calculate custom totals against data fields.
Non numerical values can only have options Count, Min and Max selected. If any other option is selected the corresponding data cells will display zeros.
For numeric values some other summary types are possible such as Sum, Average, StdDev, Var, etc.
The default value for this property is Sum.
Example (MxSpace)
To see the defined SummaryType property on a pivot field open MxSpace solution project in Visual Studio. In Solution Explorer expand node Parts and double click WorkOrderAnalysisPart.cs. Click the pivot control and run its designer. Field ActualQuantity has SummaryType property set to Average.
To define SummaryType property
- In Solution Explorer open MxPart component (WorkOrderAnalysisPart) which contains Pivot control.
- Right click the control and select option Run Designer.
- Select the desired field (ActualQuantity) in Pivot Fields section.
- Set the desired value (Average) for property SummaryType.