I cannot find a way to create a calculated field in pivot table that mutiplies 2 columns (eg Qty * price)
I want to calculate Qty * price for each row and sum the result.
Instead I get Sum of Qty * Sum of Price
Have tried sumproduct
See Example below
Table
Product Qty Price Required...