hi guys ,
please help me out in resolving this,i have requirement where i am asked to design the chart
which displays the 'sum of the previous date values for the QTY' and also it as to show the present 'today date qty' Plus the Future dates also in the chart'
i know the query can be written for it ,but i am not good in writing the sql query ,please help me out how to writ the query for it .
below is the sample of the sketch that i have attached .