How to get value from database into line items




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?

Best Answers