DIM

AGG Max

REF*

AGG Sum

Policy ID

Reporting Date

Deductible

Premium

P92340

20170101

45

100

P92340

20170201

30

200

P92341

20170101

35

150

P92341

20170201

45

250

Policy ID

Reporting Date

Deductible

Premium

P92340

20170201

30

300

P92341

20170201

45

400

Max 
Largest value 
Min 
Smallest value 
Sum 
Total of all values 
Mean 
Average value 
StdDev 
Standard deviation of values 
Count Numeric 
Number of numeric values 
Count Non Empty 
Number of values, excluding empty values: "" 
Count Distinct 
Number of distinct values 
Policy ID

Reporting Date

Deductible

Premium

P92340

20170101

45

100

P92340

20170101

30

100

P92340

20170101

35

100

Policy ID

Deductible

Premium

P92340

35

300

ID

Period

Product

Premium

P92340

201711

MOTOR_STD

164.83

P92340

201711

MOTOR_STD

2.00

P92340

201712

MOTOR_CLASSIC

220.71

P92341

201712

MOTOR_STD

164.83
