This content has been marked as final. Show 8 replies
I have data running back around 4 or 5 years. I want to show the rolling 12 month totals for a measure for the last 15 months. I have a pretty standard Calendar Script, and can get this working to a point, however the aggregation is correct for the most recent month but then wrong by increasing measure for each month backwards.
I'm trying to replicate the table below from Excel, again suspect will have to use a pivot table, hence cant use Accumulation to my knowledge?