Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to create a graph with Sales of last 12 months (June 2106 jback to July 2105) , compared with the year before (June 2015 - July 2014).
Data on the graph will have two lines ::
-> one line is the sales of 12 month from now until 12 months back
-> second line is the sales of 13 month ago until 24 months ago.
X-as contains 12 months not 24. (today we are for ex. june 2016):
Jun 2016
May 2016
Apr 2016
Mrt 2016
Feb 2016
Jan 2016
Dec 2015
Nov 2015
Oct 2015
Spt 2015
Aug 2015
July 2015
Can someone help me.
thx
May be use the As-Of Table method here: The As-Of Table