I have to create something similar to this:
DATA FROM SQL
variable date start = 25/10/2013
TABLA SALES
---------------------------
Sale date | Value
-----------------------------------
05/05/2013 1000
08/07/2013 500
30/11/2013 300
25/02/2014 1000
I NEED SALES FROM date start to 6 month with column with total for previous months
YEAR: 2013 2014
MONTH Prev Oct Nov Dec Jan Feb Mar
--------------------------------------------------------------------------------------------------------------------------
SALES 1500 0 300 0 0 1000 0
Any idea please
Im so desesperate
Thanks