How to sum certain columns without affecting other?

Question

The first section is the two rows that I am starting with. I would like to sum the bolded columns (quantity, lbs, level) but keep the rest of the information that same so it reads as the second section. What tool would you suggest to achieve this output?

AngelosPachis · Answer

Yes, that is correct @akilbour ,

You are only allowed to apply the sum operator on numeric fields only. So changing them to a Double or an Int if they are all integers will allow you to use the sum function.

akilbour · Answer

Thank you @clmc9601 for the screenshot! I tried to use the summarize tool but for some reason, it will not let me select sum for the quantity, gal, and lb field. Do I need to change them from a V_wstring maybe?

vizAlter · Answer

Hi @akilbour - Try this solution:

And, notice the configuration window for the Summarize tool:

How to sum certain columns without affecting other__vA.yxmd