Excel: Create Calculated Fields in a Pivot Table

[@MikeThomas67]

Download a copy of the file used in this video: theexceltrainer.co.uk/excel-pivot-table-calculated-fields/

[@Jennifer_J_C]

Helpful as always, thanks Mike 😊

[@pandamonium9834]

yes of course it was helpful Mike! Thank you - nice to see the big MVP plaque as well - congrats 🐼

[@phillipworts5092]

🎯 Key points for quick navigation:
00:54 *To calculate profit in a pivot table, create a new column using a formula subtracting cost from revenue.*
01:59 *Manually added profit columns are not a functional part of pivot tables and lack certain features like filtering.*
03:21 *The correct way to add calculated fields in pivot tables is via the "Calculated Field" option in the pivot table's analyze tab.*
04:00 *In the calculated field, use actual column names from the data for creating formulas.*
05:20 *Using calculated fields in pivot tables allows for comprehensive filtering options directly within the pivot table interface.*
06:13 *To show tax as a percentage of revenue in a new pivot table column, remove the revenue and use a calculated field with the formula for tax calculation.*
06:56 *Adjusting the tax rate in pivot tables is seamless by editing the formula in the calculated field settings.*
Made with HARPA AI

[@MikeThomas67]

Thank you @phillipworts5092 - saved me a job :-)