Spreadsheet: 148635d1333488297-pivot-table-editting-options-example-2
Sheet: Sheet2

Row Labels | Sum of qty
7 | 1
1 abc road | 1
generic town | 1
ny | 1
55555 | 1
9 | 2
2 abc road | 2
generic town | 2
ny | 2
55555 | 2
11 | 3
3 abc road | 3
generic town | 3
ny | 3
55555 | 3
14 | 4
4 abc road | 4
generic town | 4
ny | 4
55555 | 4
23 | 5
5 abc road | 5
generic town | 5
ny | 5
55555 | 5
24 | 6
6 abc road | 6
generic town | 6
ny | 6
55555 | 6
25 | 7
7 abc road | 7
generic town | 7
ny | 7
55555 | 7
26 | 8
8 abc road | 8
generic town | 8
ny | 8
55555 | 8
32 | 9
9 abc road | 9
generic town | 9
ny | 9
55555 | 9
34 | 10
10 abc road | 10
generic town | 10
ny | 10
55555 | 10
35 | 11
11 abc road | 11
generic town | 11
ny | 11
55555 | 11
36 | 12
12 abc road | 12
generic town | 12
ny | 12
55555 | 12
38 | 13
13 abc road | 13
generic town | 13
ny | 13
55555 | 13
41 | 14
14 abc road | 14
generic town | 14
ny | 14
55555 | 14
44 | 15
15 abc road | 15
generic town | 15
ny | 15
55555 | 15
45 | 16
16 abc road | 16
generic town | 16
ny | 16
55555 | 16
47 | 17
17 abc road | 17
generic town | 17
ny | 17
55555 | 17
48 | 18
18 abc road | 18
generic town | 18
ny | 18
55555 | 18
49 | 19
19 abc road | 19
generic town | 19
ny | 19
55555 | 19
51 | 20
20 abc road | 20
generic town | 20
ny | 20
55555 | 20
55 | 21
21 abc road | 21
generic town | 21
ny | 21
55555 | 21
59 | 22
22 abc road | 22
generic town | 22
ny | 22
55555 | 22
60 | 23
23 abc road | 23
generic town | 23
ny | 23
55555 | 23
62 | 24
24 abc road | 24
generic town | 24
ny | 24
55555 | 24
63 | 25
25 abc road | 25
generic town | 25
ny | 25
55555 | 25
64 | 26
26 abc road | 26
generic town | 26
ny | 26
55555 | 26
65 | 27
27 abc road | 27
generic town | 27
ny | 27
55555 | 27
66 | 28
28 abc road | 28
generic town | 28
ny | 28
55555 | 28
67 | 29
29 abc road | 29
generic town | 29
ny | 29
55555 | 29
68 | 30
30 abc road | 30
generic town | 30
ny | 30
55555 | 30
71 | 31
31 abc road | 31
generic town | 31
ny | 31
55555 | 31
72 | 32
32 abc road | 32
generic town | 32
ny | 32
55555 | 32
75 | 33
33 abc road | 33
generic town | 33
ny | 33
55555 | 33
76 | 34
34 abc road | 34
generic town | 34
ny | 34
55555 | 34
80 | 35
35 abc road | 35
generic town | 35
ny | 35
55555 | 35
83 | 36
36 abc road | 36
generic town | 36
ny | 36
55555 | 36
84 | 37
37 abc road | 37
generic town | 37
ny | 37
55555 | 37
85 | 38
38 abc road | 38
generic town | 38
ny | 38
55555 | 38
86 | 39
39 abc road | 39
generic town | 39
ny | 39
55555 | 39
87 | 40
40 abc road | 40
generic town | 40
ny | 40
55555 | 40
88 | 41
41 abc road | 41
generic town | 41
ny | 41
55555 | 41
91 | 42
42 abc road | 42
generic town | 42
ny | 42
55555 | 42
101 | 43
43 abc road | 43
generic town | 43
ny | 43
55555 | 43
102 | 44
44 abc road | 44
generic town | 44
ny | 44
55555 | 44
103 | 45
45 abc road | 45
generic town | 45
ny | 45
55555 | 45
106 | 46
46 abc road | 46
generic town | 46
ny | 46
55555 | 46
107 | 47
47 abc road | 47
generic town | 47
ny | 47
55555 | 47
108 | 48
48 abc road | 48
generic town | 48
ny | 48
55555 | 48
111 | 49
49 abc road | 49
generic town | 49
ny | 49
55555 | 49
113 | 50
50 abc road | 50
generic town | 50
ny | 50
55555 | 50
117 | 51
51 abc road | 51
generic town | 51
ny | 51
55555 | 51
120 | 52
52 abc road | 52
generic town | 52
ny | 52
55555 | 52
Grand Total | 1378