Subtotal functions
In reports based on Microsoft Analysis Services data sources you can use
these subtotal functions:
To apply these functions:
| Command | Function |
|---|---|
| Sum | Calculates the sum of the columns or rows and displays it in an additional row or column. |
| Count | Calculates the number of the column or row values and displays it in an additional row or column. |
| Average | Calculates the average values of the column or row values and displays it in an additional row or column. |
| Variance | Calculates the variance of the column or row values and displays it in an additional row or column. |
| Standard Deviation | Calculates the standard deviation of the column or row values and displays it in an additional row or column. |
| Minimum | Calculates the lowest of the column values or row values and displays them in an additional row or column. |
| Maximum | Calculates the highest of the column values or row values and displays them in an additional row or column. |
Right-click an element in a column or row dimension and select Subtotals. Select the subtotal to use.