I would like to create a bar graph showing the previous 12 months of (LineSalesAmount) for each month year on the bar graph. I have pasted my current iteration here. I am currently running the calculation in the expression field of the bar graph as shown below. The issue is that the chart is only summing data for which is shown on the graph. I.e. in this example, I would like to exclude April 2012, because there are only 4 months of data available. Is there any way to exclude Month-Years for which there is less than a full year of LineSalesAmount Data? Pictures of the chart and the script are below.
Thank you so much in advance!
Here is the Expression script as mentioned above.
