This week’s Management Reporter tip for Microsoft Dynamics ERP is on the benefit of Rolling 12 Months.

Rolling 12 Months: Use this to show a rolling number of periods dynamically. This is especially useful for side-by-side reports with divisions, departments, or companies. This example is a 12 month rolling, Base plus 11 periods in the past.

Column Definition: Period is BASE-11:BASE

MR 8 Column Definition

This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please contact us or visit our calendar to register for an event.

Be sure to subscribe to our blog so you don’t miss next week’s tip – Prevent Drill Down.

Register now for our next Management Reporter training on Aug. 26-27, 2020 to get more helpful tips.