Quarterly Totals in Months
In my module for forecasting salaries, I want quarterly totals in months (see attached) to be used for Superannuation calc. But I want to achieve it using MOVINGSUM (or similar) based on a "Pay" line item which resets after every 3 months.
Any help would be greatly appreciated!
P:S: turning on quarterly totals or adding/mapping another dimension say "Quarters" list is not an option