Office mockups excel.pivot-design
Spreadsheet

Saved
File
PivotTable Tools
19720
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