Pivot Table Product Prices

Hey everyone,

I have a list of products, probably about 50 with 3 different prices for each. I am trying to create a table that shows the cost of products, Price * Volume of products, by the 3 prices, so 3 rows of data. I have an example attached. I tried to create a calculated field to multiply the Price by the Volume for each separate price, but it looks like it is adding the three prices up, then multiplying that sum by each separate volume, rather than multiplying each individual price by the volume for that price. I feel like this is such an easy calculation, and I am totally brain dead with this. TIA!

Hi,

I've added a Totals Column to your original Data Table and used this in the Pivot Table.
I removed your Calculated Field and added a "Total Row" to your Data Table
If you filter on the Price Column you can confirm the Pivot Table Totals are correct.
Please see attached.

Regards

peterrc

Ha, Too easy.

Thank you!