0

I have a list which contains duplicate data for few properties and based on those properties, I want to group data and summation of other properties data.

List Example -

     Prop1     Prop2     Prop3     Bal1     Bal2 
    -----------------------------------------------
     X         Y         Z         50       50   
     A         B         C         100      200
     A         B         C         100      200

I want to group on Prop1, Prop2 and Prop3 properties and summation of Bal1 and Bal2. I need final result of this list is as below:

 Prop1     Prop2     Prop3     Bal1     Bal2 
-----------------------------------------------
 X         Y         Z         50       50   
 A         B         C         200      400

How can I modify the same list and achieve this with best practice?

Ronak
  • 127
  • 3
  • 15

0 Answers0