Suggestions on how to re-model a module

Options
CommunityMember113484
CommunityMember113484 Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

Hi,

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!
Thanks