Hi All,
Have the below Date column and the amount for 2 years ie:
Date Amt
01/30/2013 100
02/28/2013 200
03/31/2013 300
04/30/2013 400
05/31/2013 500
06/30/2013 600
07/31/2013 700
08/31/2013 800
09/30/2013 900
10/31/2013 1000
11/30/2013 1100
12/31/2013 1200 and so on...
i need to show in the bar chart the Quarter end date and their values for example the output should be same as below:-
Output:-
03/31/2013 300
06/30/2013 600
09/30/2013 900
12/31/2013 1200
Can any one help me on this..
