Hi everyone,
I am trying to show the Moving Annual Total for sales. MAT is the total sales from 51 weeks in the past to the current week.
In my view I also have to use a dimension filter to only show the current month. This breaks the calculation as it only calculates for the 4 weeks in the current month.
Is there a way I can bypass the date filter and properly calculate the MAT?
Any help would be appreciated.
2 answers
Is this the output you are looking for?
If yes, please see the solution in the updated workbook attached.
