Formula - Matrix help
I have a module dimensioned by Product and Entity which shows the total recharge required between different entities.
Screenshot below. For example, for Product A, the Investment Manager is Entity C. Entity C is required to pay 100 to Entity A and 400 to Entity B.
I'm trying now to create a matrix of sorts to show the below? however, you can't have one list on 2 dimensions? I thought about creating a secondary list, but there's no data linked to it? how do I go about this?