If you're not sure how to use Excel's pivot table formulas (calculated items and calculated fields), I've made a short video that shows how they work.
See how to set up simple formulas, and then use a built-in command to quickly create a list of all the pivot table formulas.
See the video, and more details on pivot table formulas, in my Pivot Table blog.
NOTE: These formulas are not available for pivot tables based on the Data Model.
July 23, 2020
June 04, 2020
May 28, 2020
February 06, 2020