Pivot Table to Multiply Units Sold By Price

[JumpInTheFire83]

Hi there,

I am selling on Amazon and currently wondering if Pivot Tables can be used to multiply units sold by the price they were sold at. As Amazon is so competitive, prices can change at any time and often do a lot.

Example - As you can see I have been able to work out, for each product, how many items have been sold and what price they sold at. e.g. A0274 - I can see I have sold 2 at £3.52, 3 at £3.64 and 1 at £3.70.

I can tell by calculating I have made £21.66 on this. Although this is time consuming.

Is there a formula or a way to quickly calculate the total made on this product and others

Thanks

 

[ghrain22]

You can make a calculated column.
PivotTable Tools/Options>Calculated field

I'd also recommend reorganizing your pivot table.
Try making the the code your row label and make the price and qty's values.