When creating custom views of data, you may want to perform a different aggregate function other than "Sum" on your column or row. For example, you may want to find the average or maximum values in your data. This can easily be done through the Field Settings dialog box.
To Specify the function performed on data at runtime:
- Right-click a field in the Values area of the C1OlapPanel.
- Click Field Settings in the context menu. The Field Settings dialog box opens.
- Click the Subtotals tab.
- Select one of the following options:
|
Sum
Count
Average
Maximum
Minimum
First
Last
Variance
Standard Deviation
Variance Population
Standard Deviation Population
|
Gets the sum of a group.
Gets the number of values in a group.
Gets the average of a group.
Gets the maximum value in a group.
Gets the minimum value in a group.
Gets the first value in a group.
Gets the last value in a group.
Gets the sample variance of a group.
Gets the sample standard deviation of a group.
Gets the population variance of a group.
Gets the population standard deviation of a group.
|
- Click OK to close the Field Settings dialog box. Notice how the values in the summary table change.