Rolling 12 months dynamic based on selection - aggr
I wish to show a rolling 12 month revenue graph - always showing 12 months in the dimention with a sum of the past 12 months billing for each month. I am getting stuck on two aspects:
1. How to display the MonthYear (text) as the dimension - limited to 12 months, rather than the numeric value (MonthYearSerial).
2. How to make this dynamic in terns of selection one MonthYear (from calendar), but still showing the selected moth plus the other 11 months in the graph.
I am using the aggr function with the range sum function - whcih works when no selections are made, but iealy I want the results to show as per above when various MonthYear selections are made. Below is my expresion and I ahve attacehd an example app with my data and objects.