I have a few years worth of sales data. I would like to create a simple bar chart graph that displays a rolling 12 months of data and Year to Date data. My dilemma is the data is daily. I suppose I can create a column and do Format(date,"YYYY") to get the year, but how do I capture the rolling 12 months. Thus using April 2018 as an example I should be displaying for the rolling 12 months each month from Apr 2017 to Apr 2018. For the YTD line it should be from Jan 18 to Mar 31 18.
I have tried to pivot the data, but essentially I have ended up manually creating the past 12 months of data and then the Year to date months. I know there is an easier way. Can anyone provide me with a link to a tutorial that may assist. Attached is a simple raw data example.