Copper Contributor

How do I add a custom field for multiplying 2 coulmns in excel pivot table

2 Replies


Let's say you have a PivotTable with "Quantity" in Rows and "Price" in Values. To create a calculated field for the total revenue, you would:

  1. Create a PivotTable with "Quantity" in Rows and "Price" in Values.
  2. Click on any cell within the PivotTable.
  3. Go to the "Analyze" tab on the Ribbon.
  4. Click on "Fields, Items & Sets" and choose "Calculated Field."
  5. In the "Name" field, enter "Total Revenue."
  6. In the "Formula" field, enter =Quantity * Price.
  7. Click "Add" and then "OK."

This will create a calculated field displaying the total revenue for each combination of quantity and price.

Remember, the exact steps and options might vary slightly depending on your Excel version. If you encounter any difficulties or if you're using a specific version, feel free to provide more details for further assistance. If this suggested solution doesn't help you, I recommend adding additional information.


My answers are voluntary and without guarantee!


Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.


Depends on which PivotTable you use. For such sample


if you are on cached PivotTable and add calculated field


it sums all Qty for the field A, when all Price and multiply one on another.

With data model PivotTable you may add measure

sum:=SUMX(Table1, Table1[Qty]*Table1[Price])

which iterates multiplication record by record and PivotTable returns sum of that.

Results are different.