I've been searching for an answer to this but I'm having no luck. I want to show the sales over the last 12 months, so for Jan-19 I want it to show the sum sales from Feb-18 to Jan-19. This in itself is easy enough to do using RangeSum(Above(Sum(Sales),0,12)) for example, but the issue I'm having is I want to restrict the chart to only display 2019, but I still want to keep the data from 2018 within the calculations. When I select 2019, Jan-19 only shows that months and nothing from 2018
I know there must be a way to do this otherwise every 12 months of any such graph will have incomplete data. Are you able to help?