Moving Annual Total

KumaRan — Sat, 16 Nov 2024 21:43:33 GMT

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.

Re: Moving Annual Total

KumaRan — Mon, 17 Dec 2018 06:42:14 GMT

Hi Tresesco,

This what i am looking for. Thanks for your suggestion