I have a Transaction dataset. In simplest terms, the columns shown are Entity, Item, Formula 1 or "Freight" (Cost Factor from Landed Cost Template x Quantity), Formula 2 or "Duty" (Cost Factor from Landed Cost Template x COGS per item), Amount per Line or "total COGS per item". Because each item line is joined to the landed cost template, it is being replicated based on the number of cost categories in the Landed Cost Template. As such, the amount per item line or "total COGS per item" is duplicated or so as well. My goal is to convert it to a pivot where the columns are basically the same except Item. This gives me COGS breakdown per customer. However, since the "total COGS per item" is duplicated or so, I can't just sum it in the pivot. Is there a way to sum the amounts correctly and avoid the duplications or so?