I have four columns like [start date], [end date], [item], [quantity]. Values are like
1st Row >> [1 April 2012], [30 April 2012], pen, 30;
2nd Row >> [5 April 2012], [12 April 2012], pencil, 75
and etc.
It means from 1st April to 30th April we supplied each day 30 quantity of pen; and from 5th April to 30th April each day we supplied 75 qty of pencil
Now if I want to find out total qty we supplied on 7th April, I wonder how I can find out that?
But I know he answer should be [30 + 75 = 105] in the above example.