Office mockups excel.dialog-pivot-options
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

PivotTable options

Layout
Format

Show report filter pages

Field settings

Source name: Region

Subtotals
Filter