Subtotal calculations can be specified using separate functions, different from the primary aggregation functions.
These are processed not through the query, but directly on the OLAP server.
[ Subtotal Calculation Function ]
Subtotal Method | Description |
|---|---|
None | No specific calculation applied(Use Primary Calc. Aggregation) |
SumOfChild | Sum of child dimension items |
MinOfChild | The minimum value of child dimension items |
MaxOfChild | The maximum value of child dimension items |
AverageOfChild | The Average value of child dimension items |
| CountOfChild | Number of data records for child dimension items |
Example of Summary(Total)
- Applying Summary(Total) on Target Amount, Revenue Amount, Sales Cost, and Discount Amount
[ Applying Primary Calculation ]
[ Applying Summary(Total) Function ]
