...
| 패널 | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
계산 방식
신규 계산 필드
DB 연동 필드
1차 계산
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 ( |
Hybrid 쿼리 사용할 시 소계 집계 방식 정의
Query) | Defines subtotal aggregation method when using hybrid queries | ○ | ○ |
○ |
2 | 3 | Auto, Sum, |
Count, Max, Min, Average, |
DistinctCount, |
소계 계산
1차 계산 집계가 아닌 다른 소계 방식을 적용 시 사용
AlwaysGroupBy | |||||
Summary (Total) | Used when applying a subtotal method other than the primary aggregation | X | ○ | ○ |
2 |
3
SumOfChild, MinOfChild, MaxOfChild, AverageOfChild, CountofChild |
2차 계산
Secondary Calculation | Recalculation using the result of the primary calculation | ○ | ○ | ○ |
| 3 | 4 | SubTotalPercentRow…. |