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 row fields

Create row fields - Microsoft Excel Tutorial

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

Start my 1-month free trial

Create row fields

“

- [Instructor] Okay, let's make this little pivot table here more interesting and start adding more fields to it. Specifically, we want to add some conditions that break up this value field. So we're going to go up here to our field list and we're going to drag the buyer field down to rows. There, the pivot table now has this row field that divides up the value field, that's great. And let's just take a moment and explain this user interface, this area down here at the bottom of the pivot table fields list. Sometimes you'll open this fields list up and you might think, "Okay, where do I put fields exactly?" Well, just remember that since rows is on the left here and values is on the right here, your row fields will be on the left here and your value field will be on the right. So just a little reminder in case you're ever stumped when you open up that pivot table fields list. Now let's go further and I'm actually going to add a second row field to this rows area and I'm going to drag…

Contents