From the course: Excel: PivotTables in Depth
Join today to access over 24,400 courses taught by industry experts.
Summarize more than one data field
From the course: Excel: PivotTables in Depth
Summarize more than one data field
- [Instructor] When most users think of a pivot table, they see it with a single data set in the values area. And while that's certainly the most common layout, you can summarize more than one value field at a time. And in this movie, I will show you what that looks like. My sample file is O2_03_MultipleValueFields, and you can find it in the chapter 2 folder of the Exercise Files collection. On sheet 1 of the sample file, I have a pivot table that summarizes business and individual sales for my company based on quarter for the years 2022 and 2023. And if I look in the pivot table fields task pane, I see that I have sum of Order Total. So that is the only data being summarized in the values area. If I want to add a second field, then I can just drag it from the field list down to the values area. So I'll actually do Order Total again. So I'll drag down and drag a second copy of Order Total to the values area. And now that I have that, if I look up in the pivot table, then I see I have…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
