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

Grouping

Auto
By
Seconds
Minutes
Hours
Days
Months
Quarters
Years

Move PivotTable

Place the PivotTable

Change PivotTable data source

The PivotTable refreshes from the new source; fields that are no longer there are removed from it.