How to get value from database into line items

sharmagh

Hi,

 

I have a source module where I have raw data (Rows: Flat list of Row Numbers and Columns: All the line items). Line Items: Funds formatted as Fund List, Trans Type formatted as TT list (Investment, Commitment, Proceeds) and Transaction amount.

 

In my target module I have funds as row dimension and Amount as a line item and i want to sum Investment per Fund, How it can be done?

Misbah

@sharmagh 

 

See if this helps

 

Module 1 Transaction Amount[SUM: Module 1.Funds]

nathan_rudman

you can do a SUM:
source.transaction amount[SUM:source.fund]