How to Calculate the Moving Annual Total (MAT) March 22, 2022 00:42 Follow Set up as described in How to Change your Table into a Rolling Average. Set the Number of periods to roll to whatever corresponds to a year. For example, if the Date/Time variable set is set to months, then set Number of periods to roll to 12. Related articles How to Create a Rolling Average on Tables Publishing as a Web Page (Online Report / Dashboards) How to Optimize the Speed of Displayr Documents How to Customize Default Row and Column Labels in Displayr Tables How to Build Tables that Automatically Filter to the Latest Periods
