From the course: Excel: PivotTables for Beginners

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Create column fields

Create column fields - Microsoft Excel Tutorial

From the course: Excel: PivotTables for Beginners

Start my 1-month free trial Buy for my team

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.…

Contents