Spreadsheet: 674776d1588009634-sum-data-based-on-a-gl-code-and-month-in-year-2020-04-27-oeldere-tommpalmer123-
Sheet: Output

Issue | Date | value | year | month | day
200 | 2019-01-01 00:00:00 | 75000 |  |  |  |  |  | Som van value | Kolomlabels
200 | 2019-02-01 00:00:00 | 90000 |  |  |  |  |  | Rijlabels | 2019 | 2020
200 | 2019-03-01 00:00:00 | 50000 |  |  |  |  |  | 1 | 180000 | 181120
200 | 2019-04-01 00:00:00 | 70000 |  |  |  |  |  | 2 | 196000 | 197128
200 | 2019-05-01 00:00:00 | 100000 |  |  |  |  |  | 3 | 157000 | 158136
200 | 2019-06-01 00:00:00 | 100000 |  |  |  |  |  | 4 | 178000 | 179144
200 | 2019-07-01 00:00:00 | 80000 |  |  |  |  |  | 5 | 209000 | 210152
200 | 2019-08-01 00:00:00 | 100000 |  |  |  |  |  | 6 | 210000 | 211160
200 | 2019-09-01 00:00:00 | 100000 |  |  |  |  |  | 7 | 191000 | 192168
200 | 2019-10-01 00:00:00 | 100000 |  |  |  |  |  | 8 | 212000 | 213176
200 | 2019-11-01 00:00:00 | 50000 |  |  |  |  |  | 9 | 213000 | 214184
200 | 2019-12-01 00:00:00 | 100000 |  |  |  |  |  | 10 | 214000 | 215192
210 | 2019-01-01 00:00:00 | 40000 |  |  |  |  |  | 11 | 165000 | 166200
210 | 2019-02-01 00:00:00 | 40000 |  |  |  |  |  | 12 | 205000 | 206208
210 | 2019-03-01 00:00:00 | 40000 |  |  |  |  |  | Eindtotaal | 2330000 | 2343968
210 | 2019-04-01 00:00:00 | 40000
210 | 2019-05-01 00:00:00 | 40000
210 | 2019-06-01 00:00:00 | 40000
210 | 2019-07-01 00:00:00 | 40000
210 | 2019-08-01 00:00:00 | 40000
210 | 2019-09-01 00:00:00 | 40000
210 | 2019-10-01 00:00:00 | 40000
210 | 2019-11-01 00:00:00 | 40000
210 | 2019-12-01 00:00:00 | 40000
211 | 2019-01-01 00:00:00 | 25000
211 | 2019-02-01 00:00:00 | 25000
211 | 2019-03-01 00:00:00 | 25000
211 | 2019-04-01 00:00:00 | 25000
211 | 2019-05-01 00:00:00 | 25000
211 | 2019-06-01 00:00:00 | 25000
211 | 2019-07-01 00:00:00 | 25000
211 | 2019-08-01 00:00:00 | 25000
211 | 2019-09-01 00:00:00 | 25000
211 | 2019-10-01 00:00:00 | 25000
211 | 2019-11-01 00:00:00 | 25000
211 | 2019-12-01 00:00:00 | 25000
212 | 2019-01-01 00:00:00 | 10000
212 | 2019-02-01 00:00:00 | 10000
212 | 2019-03-01 00:00:00 | 10000
212 | 2019-04-01 00:00:00 | 10000
212 | 2019-05-01 00:00:00 | 10000
212 | 2019-06-01 00:00:00 | 10000
212 | 2019-07-01 00:00:00 | 10000
212 | 2019-08-01 00:00:00 | 10000
212 | 2019-09-01 00:00:00 | 10000
212 | 2019-10-01 00:00:00 | 10000
212 | 2019-11-01 00:00:00 | 10000
212 | 2019-12-01 00:00:00 | 10000
213 | 2019-01-01 00:00:00 | 13000
213 | 2019-02-01 00:00:00 | 13000
213 | 2019-03-01 00:00:00 | 13000
213 | 2019-04-01 00:00:00 | 13000
213 | 2019-05-01 00:00:00 | 13000
213 | 2019-06-01 00:00:00 | 13000
213 | 2019-07-01 00:00:00 | 13000
213 | 2019-08-01 00:00:00 | 13000
213 | 2019-09-01 00:00:00 | 13000
213 | 2019-10-01 00:00:00 | 13000
213 | 2019-11-01 00:00:00 | 13000
213 | 2019-12-01 00:00:00 | 13000
214 | 2019-01-01 00:00:00 | 2000
214 | 2019-02-01 00:00:00 | 2000
214 | 2019-03-01 00:00:00 | 2000
214 | 2019-04-01 00:00:00 | 2000
214 | 2019-05-01 00:00:00 | 2000
214 | 2019-06-01 00:00:00 | 2000
214 | 2019-07-01 00:00:00 | 2000
214 | 2019-08-01 00:00:00 | 2000
214 | 2019-09-01 00:00:00 | 2000
214 | 2019-10-01 00:00:00 | 2000
214 | 2019-11-01 00:00:00 | 2000
214 | 2019-12-01 00:00:00 | 2000
215 | 2019-01-01 00:00:00 | 1000
215 | 2019-02-01 00:00:00 | 1000
215 | 2019-03-01 00:00:00 | 1000
215 | 2019-04-01 00:00:00 | 1000
215 | 2019-05-01 00:00:00 | 1000
215 | 2019-06-01 00:00:00 | 1000
215 | 2019-07-01 00:00:00 | 1000
215 | 2019-08-01 00:00:00 | 1000
215 | 2019-09-01 00:00:00 | 1000
215 | 2019-10-01 00:00:00 | 1000
215 | 2019-11-01 00:00:00 | 1000
215 | 2019-12-01 00:00:00 | 1000
220 | 2019-01-01 00:00:00 | 14000
220 | 2019-02-01 00:00:00 | 15000
220 | 2019-03-01 00:00:00 | 16000
220 | 2019-04-01 00:00:00 | 17000
220 | 2019-05-01 00:00:00 | 18000
220 | 2019-06-01 00:00:00 | 19000
220 | 2019-07-01 00:00:00 | 20000
220 | 2019-08-01 00:00:00 | 21000
220 | 2019-09-01 00:00:00 | 22000
220 | 2019-10-01 00:00:00 | 23000
220 | 2019-11-01 00:00:00 | 24000
220 | 2019-12-01 00:00:00 | 14000
200 | 2020-01-01 00:00:00
200 | 2020-02-01 00:00:00
200 | 2020-03-01 00:00:00
200 | 2020-04-01 00:00:00
200 | 2020-05-01 00:00:00
200 | 2020-06-01 00:00:00
200 | 2020-07-01 00:00:00
200 | 2020-08-01 00:00:00
200 | 2020-09-01 00:00:00
200 | 2020-10-01 00:00:00
200 | 2020-11-01 00:00:00
200 | 2020-12-01 00:00:00
210 | 2020-01-01 00:00:00
210 | 2020-02-01 00:00:00
210 | 2020-03-01 00:00:00
210 | 2020-04-01 00:00:00
210 | 2020-05-01 00:00:00
210 | 2020-06-01 00:00:00
210 | 2020-07-01 00:00:00
210 | 2020-08-01 00:00:00
210 | 2020-09-01 00:00:00
210 | 2020-10-01 00:00:00
210 | 2020-11-01 00:00:00
210 | 2020-12-01 00:00:00
211 | 2020-01-01 00:00:00
211 | 2020-02-01 00:00:00
211 | 2020-03-01 00:00:00
211 | 2020-04-01 00:00:00
211 | 2020-05-01 00:00:00
211 | 2020-06-01 00:00:00
211 | 2020-07-01 00:00:00
211 | 2020-08-01 00:00:00
211 | 2020-09-01 00:00:00
211 | 2020-10-01 00:00:00
211 | 2020-11-01 00:00:00
211 | 2020-12-01 00:00:00
212 | 2020-01-01 00:00:00
212 | 2020-02-01 00:00:00
212 | 2020-03-01 00:00:00
212 | 2020-04-01 00:00:00
212 | 2020-05-01 00:00:00
212 | 2020-06-01 00:00:00
212 | 2020-07-01 00:00:00
212 | 2020-08-01 00:00:00
212 | 2020-09-01 00:00:00
212 | 2020-10-01 00:00:00
212 | 2020-11-01 00:00:00
212 | 2020-12-01 00:00:00
213 | 2020-01-01 00:00:00
213 | 2020-02-01 00:00:00
213 | 2020-03-01 00:00:00
213 | 2020-04-01 00:00:00
213 | 2020-05-01 00:00:00
213 | 2020-06-01 00:00:00
213 | 2020-07-01 00:00:00
213 | 2020-08-01 00:00:00
213 | 2020-09-01 00:00:00
213 | 2020-10-01 00:00:00
213 | 2020-11-01 00:00:00
213 | 2020-12-01 00:00:00
214 | 2020-01-01 00:00:00
214 | 2020-02-01 00:00:00
214 | 2020-03-01 00:00:00
214 | 2020-04-01 00:00:00
214 | 2020-05-01 00:00:00
214 | 2020-06-01 00:00:00
214 | 2020-07-01 00:00:00
214 | 2020-08-01 00:00:00
214 | 2020-09-01 00:00:00
214 | 2020-10-01 00:00:00
214 | 2020-11-01 00:00:00
214 | 2020-12-01 00:00:00
215 | 2020-01-01 00:00:00
215 | 2020-02-01 00:00:00
215 | 2020-03-01 00:00:00
215 | 2020-04-01 00:00:00
215 | 2020-05-01 00:00:00
215 | 2020-06-01 00:00:00
215 | 2020-07-01 00:00:00
215 | 2020-08-01 00:00:00
215 | 2020-09-01 00:00:00
215 | 2020-10-01 00:00:00
215 | 2020-11-01 00:00:00
215 | 2020-12-01 00:00:00
220 | 2020-01-01 00:00:00
220 | 2020-02-01 00:00:00
220 | 2020-03-01 00:00:00
220 | 2020-04-01 00:00:00
220 | 2020-05-01 00:00:00
220 | 2020-06-01 00:00:00
220 | 2020-07-01 00:00:00
220 | 2020-08-01 00:00:00
220 | 2020-09-01 00:00:00
220 | 2020-10-01 00:00:00
220 | 2020-11-01 00:00:00
220 | 2020-12-01 00:00:00