From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Modify a PivotTable

Modify a PivotTable - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Modify a PivotTable

“

- [Instructor] All right, pivot table madness are you ready? We have this pivot table here, it is showing a sum of fines and showing it by license and by region. Here is the source data. We have the county, the name of the people who've been fined, the regions, their license types and the fine amounts. Your help is needed in showing the count of the fines instead of the sum, and then show the data by county and by license instead of license and region, but add a slicer for the region. Did you get it, I hope so. Now let me show you. I'm going to click inside the pivot table. Now I need the field list, go to pivot table analyze and then there's the field list. Now I'm going to go down to here where sum of fine, value field settings, change it to count, okay. Let's slide this out so we can see our objectives better. Okay, we want to show the data by county and by license. Click back here, field list is back. Let's…

Contents