Office mockups excel.dialog-pivot-calc
Spreadsheet

Saved
File
PivotTable Tools
Escape of water
A
B
C
D
E
F
G
H
I
J
1
Region
(All)
2
3
Row labels
Sum of Reserve (£)
Sum of Paid (£)
Count of Claim
4
Storm
7,110
5,250
3
5
Escape of water
19,720
2,500
4
6
Jane Doe
14,770
2,500
3
7
Mark Rivera
4,950
0
1
8
Fire
17,240
6,000
2
9
Theft
4,545
1,180
3
10
Subsidence
28,200
1,500
2
11
Accidental damage
1,160
540
2
12
Grand total
77,975
16,970
16
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Insert calculated field

Fields
Claim
Policyholder
Peril
Reported
Reserve (£)
Paid (£)
Outstanding (£)
Status
Handler
Days
Region

Insert calculated item

Fields
Peril
Status
Region
Items of Peril
Accidental damage
Escape of water
Fire
Flood
Storm
Subsidence
Theft

Solve order

Calculated items are evaluated in this order:

Water total = 'Escape of water' + Flood
Weather total = Storm + Flood