Calculation Method | Property Definition | Applicable Target | Calculation Location | Calculation Order | Applicable Functions | |||
|---|---|---|---|---|---|---|---|---|
New Calculated Field | DB Linked Field | OLAP Server | DB | General Query | Hybrid Query | |||
Primary Calculation | Basic aggregation properties for items | ○ | ○ | ○ |
| 1 | 1 | Sum, Min, Max,Average,Count, DistinctCount,Text |
Aggregation (Query) | Defines subtotal aggregation method when using hybrid queries | X | ○ | ○ | 2 | Sum, Count, Max, Min, Average, DistinctCount, AlwaysGroupBy | ||
Summary (Total) | Used when applying a subtotal method other than the primary aggregation | ○ | ○ | ○ | 2 | 3 | SumOfChild, MinOfChild, MaxOfChild, AverageOfChild, CountofChild | |
Secondary Calculation | Recalculation using the result of the primary calculation | ○ | ○ | ○ |
| 3 | 4 | SubTotalPercentRow…. |