Calculate values dialog

To open the Calculate values dialog, do one of the following on a table or chart page:

Click Table options / Chart options> Calculate values
Select View menu> Table options / Chart options> Calculate values

To enable calculations, first select a hierarchy and then choose the calculations you want to enable for each measure.

If Totals is selected, you can specify how the calculations will be applied. (This choice will affect totals, percentages, custom groups, custom bands, and YTD time-series calculations.) The following functions are provided:
- Aggregate -- This is the default method, defined when a cube is created. In most cases it produces "smart totals" with no double counting.
- Sum -- A simple sum. May include double counts.
- Max -- Returns the maximum value.
To cancel changes and close the Calculate dialog, click Cancel.
To clear all calculations, click Clear all.

Note: Not all Perspective sites will have enabled calculations.

Note: Calculated values are not affected by sorting.

Calculation details

Totals

If selected, a Total row or column appears in Perspective reports. It shows the sum of all the values in the selected dimension.

Percentages

If selected, data values are expressed as percentages in Perspective reports. Percentages are calculated across or along the selected dimension.

Values and percentages can both be viewed at once if preferred. Select Display values and percentages together.

Average

If selected, an Average row or column appears in Perspective reports. It shows the average of the values in the selected dimension.

The calculation method for Average is as follows:

Where N is the total count number of the Xi.

Median

If selected, a Median row or column appears in Perspective reports. It shows the median value in the dimension.

Median is the value below which 50% of the scores fall, or the middle score. The calculation method for Median is as follows:

When there is an odd number of numbers, the median is the middle number.
For example: The median of 2, 4, and 7 is 4.
When there is an even number of numbers, the median is the mean of the two middle numbers.
For example: The median of the numbers 2, 4, 7, and 12 is (4+7)/2 = 5.5.

Minimum

If selected, a Minimum row or column appears in Perspective reports. It shows the lowest non-null value in the dimension.

Maximum

If selected, a Maximum row or column appears in Perspective reports. It shows the highest non-null value in the dimension.

Variance

If selected, a Variance row or column appears in Perspective reports. It shows the variance (unbiased) of the values in the dimension.

Variance is a measure of statistical dispersion. It indicates how far values differ from the expected values. The calculation method for Variance is as follows:

Where M is the mean of the Xi and N is the total count number of the Xi.

Standard deviation

If selected, a Standard deviation row or column appears in Perspective reports. It shows the standard deviation (unbiased) of the values in the dimension.

Standard deviation is the square root of the variance. The calculation method for Standard deviation is as follows:

Where M is the mean number of the Xi and N is the total count number of the Xi.