Sum of the maximum underlying field

Hi all,

I have a table that looks something like this:

I want to remove 'id' and then sum the max pieces sent to rollup properly under customer_segment.

If I need to I can try and put something together in a workbook to upload but it's sort of confidential info.

Thanks for any help,

Charles