But then do a Rolling on top of the rolling he is doing. So basically I want to have rolling 3 month Sales that Rolls 12 months. So my trend line would have:
Month Rolling 3 Month Sum Sales Sales
Dec 3000 1000
Nov 3200 500
Oct 2700 1500
Sept 2750 1200
This is my code I would like to show the Rolling Sum of Sales for each of the above months in a single Trend Line. However, when I put this measure into a graph it simply shows the last 3 months of Sales broken out.
Have you noticed that "It is important to know that putting the Month from the Date table will not work, so what we are going to do is create a month column in the Sales table and then use that as the axis for the bar chart.", which is mentioned in above link?
Community Support Team _ Yuliana Gu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.