Change aggregation pattern.
here is the scenario I am working with. The data in my dataprovider is in the following format.
Doc no. Line Item Processing no Amount1 Amt 2
12345 1 1 10000 2000
12345 1 2 10000 3000
12345 2 1 8000 5000
Doc No. Amt 1 Amt2
12345 18000 10000
Please note that the requirement is that "Amount1" should not be aggregated across the Processing no. i.e. the 2 records with the same Doc no. and Line Item should give me an aggregate result of 10000 and not 20000 but when the Line Item changes, the values should be aggregated. Amt 2 is not an issue as they are all aggregated.
Suggestions on how to achieve this is highly appreciated,