Calculated Aggregates
Calculated Aggregates
The PivotEngine support GetAggregateValue function in PivotField to calculate aggregate field for each summary row.
Features
Description
PivotField objects have two properties as function that support custom calculations:
And uses GetAggregateValue function to calculate a Conversion field that shows the Sales/Downloads ratio for each summary row.
- The GetValue function takes a data item as a parameter and returns a value that is calculated based on other properties of the data item. The function has no access to any aggregate information.
- The GetAggregateValue function takes a summary row as a parameter and returns a value to be displayed as an aggregate for the field. The function has no access to the individual/raw data items.
And uses GetAggregateValue function to calculate a Conversion field that shows the Sales/Downloads ratio for each summary row.