I have a client that wants a report I have never seen - they want the balance sheet section of a row definition to show the 13 months average balance of all balance sheet accounts - normally I could do this in a column, however, the columns are restricted already to locations, sale type and department. So, I want to know if I can somehow put an account modifer in the row to total the last 13 periods, in a NP row, then in a printing row, take that total and divide by 13.
I don't see a way to get the row to display Current period through 12 more months prior.
*This post is locked for comments