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 · Accepted solution]

@sharmagh 

See if this helps

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

[nathan_rudman · Accepted solution]

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