Standard Pivot Tables have a simple feature for creating calculated fields.

you’re free to think of a calculated field as a virtual column in the source data.

The pivot table displays the calculated unit price for each product in the source data.

Field list after adding calculated field

A fourth field called “Unit Price” is a calculated field.

Field list after adding calculated field

Field list after adding calculated field

Field list after adding calculated field

Field list after adding calculated field

Select “Insert Calculated Field” from this menu

The Insert Calculated Field window

Unit Price value field settings