Creating a percentage with a calculated field in Google Sheets or Excel - Tutorial

Check out my new Advanced PivotTable class for 2021 here: https://skl.sh/3ho0SOi

If you want to calculate the rate or percentage of something in a PivotTable, you'll have to use a calculated field. If the column you're try to calculate the percentage off of is a text column, this can get a little tricky.

In this tutorial, we have customer attrition data and there is an "Attrition" column that has "Yes" or "No" in the column to indicate if the customer churned. To calculate the Attrition percentage no matter how you set up the PivotTable, you have to add some data to the underlying data source the PivotTable is based on. Once you have these numeric columns, you can create a calculated field that can be used as another property in your PivotTable.

* Intro - 0:00
* Create PivotTable - 1:28
* Add "Attrition" to PivotTable - 2:43
* Add a calculated field with IF statement - 3:06
* Add "Attrition" in the PivotTable columns - 4:06
* SOLUTION: Add a COUNT and Attrition Flag columns - 6:10
* Add calculated field with newly created columns - 7:36

👉 New 2021 advanced PivotTable class: https://skl.sh/3ho0SOi
👉 Copy the Google Sheet: https://docs.google.com/spreadsheets/...
👉 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast...
👉 Follow on Instagram:   / dear.analyst  
👉 Original blog post for this podcast episode: https://www.thekeycuts.com/dear-analy...
👉 Excel for the Real World online class: https://skl.sh/2lsi6up