From the course: Excel: PivotTables for Beginners
Unlock this course with a free trial
Join today to access over 23,100 courses taught by industry experts.
Create column fields - Microsoft Excel Tutorial
From the course: Excel: PivotTables for Beginners
Create column fields
- [Instructor] Pivot tables can give you very specific insights of your data, and one way to do that is with column fields. In this pivot table, you can see have a grouping. I've got the buyer field grouped under the month field. But let's move the buyer field over to the columns area and see what happens. Cool, now we have the row field for months, which is here. And now we have the column field for the buyer, which is here. And they're all dividing up that value field, which is sum of amount. It's also good to know that you can group column fields too, like we did for the row field. So I'm going to go ahead, I'm going to drag the type field down underneath the buyer field in the columns area. And there, we've got that grouping. And let me explain how this is all laid out here. You've got your row field for months, you've got your column field for buyer, and then grouped underneath that is the column field for type.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.