Greetings!
I am having trouble with a Rolling 12 graph. When no year is selected all the figures are correct. But since my formula is using ABOVE, when selecting a specific year there are no rows above and the sum starts from the first selected month. I need the year-slice to show the same values as from when no specific filter on year is set.
This is how I do it:
RangeSum(Above(Sum({$<YearMonth = {"<=$(=max(YearMonth))"}>}[Data]),0,12))
I know I probably must do something in the script when I load the data but I cannot figure out what.
Please, any suggestions?
/Peter