I'm currently trying to build an Income Statement in a D365F Account Schedule. What I can't seem to be able to do is get a row that shows me a total of revenue accounts by dimension. I can get the total of the revenue accounts, but cannot assign a dimension filter to the row. For instance:
Income - Facility 1 (this is defined in accounts 3000 and 5030, Dimension 1=20, Dimension 2=10)
Income - Facility 2 (this is defined in account 3000 and 5030, Dimension 1=20, Dimension 2=20)
It seems that I should be able to do this in the Overview panel for the Account Schedule, but it doesn't store the values I assign. When I edit the Overview panel in Excel and add the all the fields to the query, I can see that the records for each of the rows in the schedule have an underlying set of dimension code fields. I tried adding dimension values and publishing, but it didn't save my entries.
Is there a way I can set dimension filters to the rows in an account schedule?
Thanks!
Chris
