I've been looking at the forums and reading various threads on setting up a chart that calculates on a rolling 12 month basis and I have two questions that I have not been able to figure out on my own.
I have attached a sample app and have two outstanding items I would like to complete:
I need the calculation to work correctly when you click on one month. Right now that is not working. I've tried a few things but I can't seem to get this right.
I only want the chart to show the last 10 months, but it should calculate the values for the full rolling 12 months. When I use set analysis for this, I get 10 months displayed but the rolling 12 calculate properly.