Defines how a summary value calculated against the current data field is represented in a cell.
Remarks
Property specifies how the value of a specific cell is calculated. For each value, the control calculates a summary against a corresponding data field.
Name | Description |
---|---|
AbsoluteVariation | The absolute variance between the current value and the previously calculated value for the current field is displayed in the cell. |
Default | The calculated summary values are displayed as they are. |
PercentOfColumn | For data cells, the percentage of the column's total value is displayed; for total cells, the percentage of the column's grand total value is displayed. |
PercentOfRow | For data cells, the percentage of the row's total value is displayed; for total cells, the percentage of the row's grand total value is displayed. |
PercentVariation | The percentage variance between the current value and the previously calculated value for the current field is displayed in the cell. |
Example (MxSpace)
To see the defined SummaryDisplayType 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 StartDate has SummaryDisplayType property set to Default.
To define SummaryDisplayType 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 (StartDate) in Pivot Fields section.
- Set the desired value (Default) for property SummaryDisplayType.