I'm combining data from multiple sheets in a PivotTable (Excel 2013 allows this) in order to calculate the margin obtained per each item in a invoice and the total margin in the invoice, in case the invoice has multiple items.
The point of contention is that sometimes there are products that when sold in a certain quantity there will be 1 item free of charge, for instance:
15 cases of item X (and on the next line of the invoice)
1 case of item X free of charge
This means that the margin of the product X will decrease. Can anyone help me go about this calculation in my PivotTable ?
Thank you.
Bookmarks