Excel

Copper Contributor

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

2 Replies

@Ayaz1972 

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.

@Ayaz1972 

Depends on which PivotTable you use. For such sample

image.png

if you are on cached PivotTable and add calculated field

image.png

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.