rendered paste bodyA B C
10011 4.99 2
10011 9.95 2
10011 4.99 3
10011 9.95 1
10011 5.87 5
10011 119.95 3
10012 38.95 1
10012 39.95 1
10012 14.99 5
10014 9.95 1
10014 14.99 1
10014 109.92 1
10014 256.99 1
10014 6.99 3
10014 9.95 1
10015 14.99 2
10015 4.99 1
10018 5.87 12
now I need a need table with only unique values of A, with the sum of B*C like this
10011 $444.00
10014 $422.77
10012 $153.85
10015 $34.97
10018 $70.44
I get this
10015 1126.03
10014 1126.03
10016 1126.03
10010 1126.03
10013 1126.03
10017 1126.03
10011 1126.03
10012 1126.03
10018 1126.03
10019 1126.03