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.
A fourth field called “Unit Price” is a calculated field.