Hi @BAOX17175074,

This is an example of simple aggregation, you can achieve this in easy or hard way.

Easy or shorter method :

• Create an activity and do RDB-List.
• With Connect SQL like "Select Year, Person, SUM(AmountA),SUM(AmountB),SUM(AmountC) from TableName Group by Year, Person".

Hard or longer way : 

• Create a DT and one pagelist to store result.
• IN DT sort the original pagelist by Year and Person.
• Create param : ASUM, BSUM, CSUM. CurrYear, CurrPerson (all sum should be 0 and string should be null)
• Loop the sorted pagelist and implement below steps:
  • If CurrYear, CurrPerson are null then set them to current iteration's year and person also append new page in new pagelist with this year and person.
  • If CurrYear, CurrPerson are null or matching with current iteration's year and person  then add AmountA, AmountB, and AmountC value to ASUM, BSUM, CSUM.
  • When Current iterator Year and Person if not matching with CurrYear or CurrPerson then update last page in new pagelist with sums(Like newpageList(<LAST>).AmountA = ASUM) and set ASUM, BSUM, CSUM to zero
  • When Current iterator Year and Person if not matching with CurrYear or CurrPerson then set them to current iteration's year and person also append new page in new pagelist with this year and person.
• After loop update last page in new pagelist's amount with all sum params(Like newpageList(<LAST>).AmountA = ASUM)

Hope it Helps !

Thanks, Ankit