I'm looking for similar functionality to management reporter in AX365, the ability to have different dimension values (like business units or departments) be columns of information in the same report, like an income statement. So would look something like:
DEPT 1 DEPT 2 DEPT 3 TOTAL
OPERATIONS SALES ACCOUNTING ALL DEPTS
INCOME 0 50,000 0 50,000
EXP line 1 (10,000) (2,000) (1,000) (13,000)
EXP line 2 (5,000) (5,000) (7,000) (17,000)
total exp (15,000) (7,000) (8,000) (30,000)
NET INCOME (15,000) (43,000) (8,000) 20,000
