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
CountOfChildNumber of data records for child dimension items


Example of Summary(Total)


[ Applying Primary Calculation ]


[ Applying Summary(Total) Function ]