Hi,
I have 3 column, amount, date, week.
i need a bar chart which rolling 13 week from max of week column and sum of the amount.
please help
Amount Date week
12000 Apr 07 10
26000 Apr 07 10
16000 Apr 014 11
6000 Apr 014 11
26000 Apr 21 12
6000 Apr 28 13
46000 May 4 14
12000 May 4 15
36000 May 11 16
16000 May 11 17
6000 May 18 18
21000 May 18 18
6000 May 25 19
46000 May 25 19
36000 Jun 1 20
16000 Jun 18 21
6000 Jun 18 21
21000 Jun 26 22
6000 July 2 23
46000 July 9 24