Hi, You can create a custom field, Under PivotTable Analyze tab- Fields, Items, & Set- Calculated Field...:
Try this method and check the result.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.