Hi all,
I have to find Moving annual total. Its not like Rolling 12 months display.
X axis has to display last 12 months. But each month(Bar) should show total of previous 12 months from that particular month
For example if current month is Nov 2018
X Axis
Oct 18 - Sep 18+ Aug 18+ Jul 18+ Jun 18+ May 18+ Apr 18+ Mar 18 +Feb 18+ Jan 18+ Dec 17+ Nov 17 +Oct 17
Sep 18 - Aug 18+ Jul 18+ Jun 18+ May 18+ Apr 18+ Mar 18 +Feb 18+ Jan 18+ Dec 17+ Nov 17 +Oct 17+sep 17
Aug 18 - Jul 18+ Jun 18+ May 18+ Apr 18+ Mar 18 +Feb 18+ Jan 18+ Dec 17+ Nov 17 +Oct 17+sep 17 +Aug 17
Jul 18 - Jun 18+ May 18+ Apr 18+ Mar 18 +Feb 18+ Jan 18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17
Jun 18 - May 18+ Apr 18+ Mar 18 +Feb 18+ Jan 18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17
May 18 - Apr 18+ Mar 18 +Feb 18+ Jan 18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17 +May 17
Apr 18 - Mar 18 +Feb 18+ Jan 18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17 +Apr 17
Mar 18 - Feb 18+ Jan 18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17
Feb 18 - Jan 18+ Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17+ Feb 17
Jan 18 - Dec 17+ Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17+ Feb 17+ Jan 17
Dec 17 - Nov 17 +Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17+ Feb 17+ Jan 17 + Dec 16
Nov 17 - Oct 17+sep 17+Aug 17+ Jul 17+Jun 17+May 17+Apr 17+ Mar 17+ Feb 17+ Jan 17+ Dec 16 + Nov 16
Can you suggest me is it possible? If so can you suggest me solution?
Thanks in anticipation.
