Hi,
Im using a table from an oracle database. This is a part of that table:
| PERIODPAYMENT | STARTDATE | PERIODMONTH | ENDDATE | NEXTPAYDATE | LASTPAYDATE | AMOUNT |
| Subsidie 1e kw. 2013 | 1-1-2009 0:00 | 3 | 31-12-2013 0:00 | 1-4-2013 0:00 | 1-1-2013 0:00 | 124 |
| Stimuleringssubsidie afgewezen voor 2011 | 1-1-2003 0:00 | 2 | 31-12-2010 0:00 | 1-1-2011 0:00 | 1-10-2011 0:00 | 1065 |
| Subsidie gestopt | 1-1-2009 0:00 | 1 | 31-12-2010 0:00 | 1-1-2011 0:00 | 1-12-2010 0:00 | 1081 |
| Subsidie 4e kw.2011 | 1-1-2009 0:00 | 3 | 31-12-2011 0:00 | 1-1-2012 0:00 | 1-10-2011 0:00 | 499 |
| Fractievergoeding 1e kw.2013 | 1-4-2006 0:00 | 3 | 31-3-2014 0:00 | 1-4-2013 0:00 | 1-1-2013 0:00 | 104,94 |
| Subs.aangepast sporten 1e kw. 2013 | 1-1-2003 0:00 | 3 | 31-12-2013 0:00 | 1-4-2013 0:00 | 1-1-2013 0:00 | 1392 |
| subsidie 1e kw. 2013 | 1-4-2011 0:00 | 3 | 31-12-2013 0:00 | 1-4-2013 0:00 | 1-1-2013 0:00 | 463 |
| subsidie 1e kw. 2013 | 31-3-2010 0:00 | 3 | 31-12-2013 0:00 | 1-4-2013 0:00 | 1-1-2013 0:00 | 4938 |
I want to show the sum of the amount for each value from the column PERIODPAYMENT by the date, but als the payments in the future. The trick is the PERIODMONTH field, which shows the interval of the payment.
So for example when i click on the year 2013 and click on the value 'subsidie 1e kw. 2013' i see sum of the amount by the following months: Jan, Mar, Jun etc.
Does someone know how i can make this work?
