Suggestions on how to re-model a module
I currently have a Debt Reporting module in Anaplan which is built on the list P6 Bank Loans.
How it flows is P3 Products > P4 Fund Entities > P6 Bank Loans.
So within certain products, there may be several bank loans under the same facility. What would be the best way to report under Facility, rather than Bank Loans?
I have tried to create a new Facility List, and attach a facility number to each P6 Loan. In my new 'Output' module, I have it dimensioned by Facility List and P3 Products and tried to lookup/sum on the underlying data but it's coming up as nil (Drill down unavailable for this cell: No other data cells are referenced by this calculation.) Any help is appreciated!