Hello
I need help with an issue i have and i can't figure how to do it with Pivot Table (or other way if easier).
I have a list of sales done for different products(product id, quantity, sold price, tota price, ) and i want to do a summery of all prudcts based on price sold, quantity at price sold and sum.
When i try to use Pivot i can't get this type of view because the same product could be sold and different prices. Pivto either gives me the avare of price sold or the sum but doesnt group the products by quantity sold at a price.

Here it is how my data looks like:

Product ID Quantity (units) Unit Price(euro) Total Sales (euro)
Product A 5 7 35
Product A 10 4 40
Product A 6 8 48
Product A 5 4 20
Product A 2 7 14
Product A 50 4 200
Product B 3 10 30
Product B 10 20 200
Product B 4 10 40
Product B 5 11 55
Product B 2 10 20
Product B 50 10 500


And i want to create the following type of summery table

Product ID Quantity (units) Unit Price(euro) Total Sales (euro)

Product A 7 7 49
Product A 65 4 260
Product A 6 8 48

Product B 59 10 590
Product B 10 20 200 .
Product B 5 11 55


Is there a way to do this with a pivot table or other easy way that doesnt take a lot of manual work since i have data list of 200k lines and many different price variations

Thank you in advance for your help.

Best Regards
R