Aggregate value of lineitem
I need to aggregate of a line item-1 with number of accounts and display in another lineitem2 in same module.
Line Item 1 - Total Sales Revenue by Account (Each product family has number of accounts under it)
LineItem 2 Total Revenue by Country = SUM of account sales target of all the accounts coming under that country and product family. Screen shot below.(13868+24418+14757+19180) for chocolate family
Any help appreciate ..