From the course: Excel: PivotTables for Beginners (2018)

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Create column fields

Create column fields - Microsoft Excel Tutorial

From the course: Excel: PivotTables for Beginners (2018)

Start my 1-month free trial

Create column fields

“

- [Instructor] Pivot tables can give you very specific insights on your data, and one way to do that is with column fields. In this pivot table, you can see I have a row field for months, and then I have the value field for sum of amount. Now I'm going to add a column field by dragging the type field down to columns. And then I'll scroll over to the right a little bit so you can see the whole thing. Now you can see we have that row field of months, and we have column fields that are dividing up that sum of amount field. In this case, it works pretty good. I have got the months here, and then inside each month I can see how much was spent on each category of purchase. You can also add secondary column fields like we did with secondary row field. So I'm going to go ahead and I'm going to drag the buyer under the type field here in the columns area. And I'm going to have to really scroll this time to see everything. And you'll see that what happens is that each month of transactions are…

Contents