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.

Please fix this PivotTable

Please fix this PivotTable - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Please fix this PivotTable

“

- [Instructor] Pivot tables. They are great, except for this one. Here, we see a total of $2,675, but let's look at the source data. Go back here sheet one, highlight total. Now we see that the total should be $3,390. So something is wrong. Also, this source data is not set up to be pivot table friendly. So there's two things. Let's go back to this pivot table. One, correct the existing pivot table. Second, remake a pivot table, but using better practices. And in that new pivot table get a sum of the quantities by item and category. Pause the video, worked that out, come back and I'll go through it. Alright, let's look into this. Usually when a pivot table is weird, it's not capturing all of the source data. Let's check that out. Cursor inside the pivot table. Pivot table analyze. Change data source, change data source. Look at that. The pivot table is only capturing the source data up to row 29. It needs to…

Contents