Spreadsheet: 552040d1513265521-how-do-you-hide-various-columns-on-a-pivot-table-with-no-table-book2
Sheet: Before 2 

FY | (All)
Count of GBP | Column Labels |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table
 | 2017 |  |  |  |  |  |  |  | 2017 Total | (blank) | (blank) Total | Grand Total |  |  |  | FY | Year | Period
Row Labels | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | (blank) |  |  |  |  |  | 2017/18 | 2017 | 4
102 | 7 | 7 | 7 | 8 | 8 | 7 | 7 | 9 | 60 |  |  | 60 |  |  |  | 2017/18 | 2017 | 5
103 |  | 1 | 2 | 1 | 2 |  | 1 |  | 7 |  |  | 7 |  |  |  | 2017/18 | 2017 | 6
104 | 1 | 1 | 2 | 1 | 3 | 1 | 2 | 2 | 13 |  |  | 13 |  |  |  | 2017/18 | 2017 | 7
107 | 12 | 9 | 10 | 9 | 12 | 8 | 8 | 10 | 78 |  |  | 78 |  |  |  | 2017/18 | 2017 | 8
108 | 1 |  | 1 |  |  | 2 | 1 | 1 | 6 |  |  | 6 |  |  |  | 2017/18 | 2017 | 9
109 | 1 | 1 | 2 | 1 | 3 | 1 | 2 | 2 | 13 |  |  | 13 |  |  |  | 2017/18 | 2017 | 10
112 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 26 |  |  | 26 |  |  |  | 2017/18 | 2017 | 11
113 | 1 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 21 |  |  | 21 |  |  |  | 2017/18 | 2017 | 12
115 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 |  |  | 8 |  |  |  | 2017/18 | 2018 | 1
117 | 5 | 8 | 10 | 8 | 12 | 8 | 8 | 8 | 67 |  |  | 67 |  |  |  | 2017/18 | 2018 | 2
118a | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 120 |  |  | 120 |  |  |  | 2017/18 | 2018 | 3
118b | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 120 |  |  | 120 |  |  |  | 2017/18 | 2018 | 4
118c | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 120 |  |  | 120 |  |  |  | 2017/18 | 2018 | 5
118d |  |  | 1 | 1 |  | 1 | 2 | 1 | 6 |  |  | 6
119a | 21 | 15 | 16 | 20 | 15 | 12 | 11 | 11 | 121 |  |  | 121
119b | 4 | 3 | 4 | 4 | 4 | 2 | 3 | 3 | 27 |  |  | 27
120 | 30 | 30 | 30 | 30 | 30 | 28 | 28 | 28 | 234 |  |  | 234
121 | 47 | 52 | 48 | 48 | 52 | 52 | 49 | 49 | 397 |  |  | 397
124 | 5 | 7 | 8 | 7 | 9 | 7 | 7 | 7 | 57 |  |  | 57
125 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 |  |  | 8
126a | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 12 | 103 |  |  | 103
126b | 13 | 13 | 13 | 13 | 13 | 14 | 14 | 12 | 105 |  |  | 105
126c | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 12 | 103 |  |  | 103
126d | 2 | 3 | 3 | 3 | 3 | 3 | 2 |  | 19 |  |  | 19
127a | 6 | 5 | 5 | 5 | 4 | 6 | 3 | 7 | 41 |  |  | 41
127b | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 |  |  | 8
128 | 33 | 39 | 43 | 38 | 42 | 41 | 41 | 34 | 311 |  |  | 311
129 | 33 | 40 | 34 | 27 | 29 | 31 | 31 | 36 | 261 |  |  | 261
130 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 24 |  |  | 24
131 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 16 |  |  | 16
132 | 6 | 6 | 6 | 6 | 5 | 6 | 5 | 7 | 47 |  |  | 47
133 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 7 |  |  | 7
134 | 6 | 5 | 3 | 4 | 4 | 4 | 4 | 5 | 35 |  |  | 35
135 | 17 | 14 | 11 | 17 | 12 | 12 | 9 | 20 | 112 |  |  | 112
136 | 6 | 8 | 6 | 4 | 5 | 3 | 3 | 4 | 39 |  |  | 39
137b |  | 1 | 1 |  |  |  |  | 1 | 3 |  |  | 3
138 | 5 | 4 | 4 | 5 | 5 | 5 | 5 | 4 | 37 |  |  | 37
139 | 4 | 9 | 9 | 8 | 4 | 6 | 13 | 4 | 57 |  |  | 57
140 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 |  |  | 8
141 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 18 |  |  | 18
142 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 7 |  |  | 7
143 | 7 | 6 | 6 | 3 | 3 | 4 | 5 | 4 | 38 |  |  | 38
146a | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 9 | 93 |  |  | 93
146b | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 9 | 93 |  |  | 93
146c | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 9 | 93 |  |  | 93
147a | 45 | 45 | 44 | 43 | 43 | 47 | 41 | 37 | 345 |  |  | 345
147b | 2 | 1 | 2 | 2 | 1 | 1 | 1 | 4 | 14 |  |  | 14
148 | 2 | 2 | 2 | 2 | 2 | 2 |  | 1 | 13 |  |  | 13
149 | 3 |  | 1 | 1 | 1 | 3 | 2 | 2 | 13 |  |  | 13
151 | 33 | 28 | 29 | 25 | 26 | 22 | 30 | 25 | 218 |  |  | 218
152b | 6 | 8 | 6 | 7 | 7 | 6 | 5 | 7 | 52 |  |  | 52
154 | 10 | 10 | 8 | 10 | 5 | 7 | 7 | 8 | 65 |  |  | 65
155 | 7 | 4 | 5 | 3 | 4 | 3 | 3 | 2 | 31 |  |  | 31
156 | 7 | 6 | 7 | 7 | 7 | 7 | 6 | 7 | 54 |  |  | 54
157 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 |  |  | 8
158 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 |  |  | 8
160 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 |  |  | 8
161 | 2 | 3 | 2 |  |  | 3 | 1 | 2 | 13 |  |  | 13
164 | 6 | 6 | 7 | 6 | 9 | 8 | 7 | 10 | 59 |  |  | 59
167 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 |  |  | 8
168 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 |  |  | 8
170 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 16 |  |  | 16
171 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
173 |  |  |  |  |  |  | 1 | 10 | 11 |  |  | 11
174 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 18 |  |  | 18
178 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 30 |  |  | 30
180 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 9 |  |  | 9
(blank)
Grand Total | 533 | 540 | 540 | 516 | 525 | 512 | 508 | 515 | 4189 |  |  | 4189