Hi All,
I am trying to design the Line chart for last 5 months trend for each month of max date values.
But some cases some products have max date till today and some products have previous month dates as max date.
below is the sample data ,For Product 'A' max date is today ,Product 'B' max date is june12th and Product C max value is may18th,
same values(180 for Product B) we need show for june30 , july31 and aug31
same for product c also
INPUT:
Product | CalDate | Cumulative Sales |
A | 4/14/2015 | 100 |
A | 5/29/2015 | 180 |
A | 6/22/2015 | 200 |
A | 9/02/2015 | 300 |
B | 4/15/2015 | 120 |
B | 5/7/2015 | 150 |
B | 6/12/2015 | 180 |
C | 4/22/2015 | 200 |
C | 5/18/2015 | 320 |