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.