Values from multiple line items into one line item split by a dimension

Not sure if this is possible. 

I have multiple line spread across multiple modules.   

I want to be able to bring all the values into one line item in a seperate module which it split by a dimension reprenting each of the unique line items.   

So I have:

Module 1 with Line Item A

Module 2 with Line Item B

 

I want Module 3 with Line Item C that has a dimension that consists of A and B

 

 

Tagged:

Answers