Hi all,
I have the following source data and i want to create end of year totals. Can you help?
BOOKING DATA:
| Name insures | Loss number | Date of loss | Booking nr. | Bookdate | Incurred | Paid |
| A | 1 | 3-4-2015 | 1 | 3-4-2015 | 625000 | 500000 |
| A | 1 | 3-4-2015 | 2 | 12-7-2016 | -100000 | 0 |
| A | 1 | 3-4-2015 | 3 | 3-5-2017 | 50000 | 0 |
| B | 2 | 7-7-2015 | 4 | 9-7-2015 | 110000 | 60000 |
| B | 2 | 7-7-2015 | 5 | 8-8-2017 | -50000 | 0 |
| C | 3 | 12-12-2016 | 6 | 12-12-2016 | 25000 | 25000 |
An object that i want to create:
| Name insured | Loss
number | Date of loss | | 31-12-2015 | 31-12-2016 | 31-12-2017 |
| A | 1 | 3-apr-15 | Incurred | 625.000 | 525.000 | 575.000 |
| Paid | 500.000 | 500.000 | 500.000 |
| Outstanding | 125.000 | 25.000 | 75.000 |
| B | 2 | 7-jul-15 | Incurred | 110.000 | 110.000 | 60.000 |
| Paid | 60.000 | 60.000 | 60.000 |
| Outstanding | 50.000 | 50.000 | 0 |
| C | 3 | 12-dec-16 | Incurred | 0 | 25.000 | 25.000 |
| Paid | 0 | 25.000 | 25.000 |
| Outstanding | 0 | 0 | 0 |
In this example you see 3 years of data, but i want to show varaible 3, 4, 5, 6, .. years of booking data.
Regards,
Arjan
