From the course: Excel: PivotTables in Depth
Join today to access over 24,400 courses taught by industry experts.
Change the data field summary operation
From the course: Excel: PivotTables in Depth
Change the data field summary operation
- [Instructor] Most data lists you summarize using pivot tables will contain some sort of financial or personnel data. You'll often want to find the sum of the values in the list, but you're not limited to doing that. You can choose from several summary calculations and also have the ability to change the type of value shown in the data area. And in this movie, I will show you how to change those summaries. My sample file is 02_02_Summary, and you can find it in the chapter two folder of the exercise files collection. On sheet one of this workbook, I have a pivot table, and if I look over in the pivot table field's task pane, and if you don't see that, make sure that you have clicked a cell in the body of the pivot table, and then on PivotTable Analyze, make sure that field list is selected. Then go down to the values area, and you can see the sum of order total label for the field that is currently there. And also if you move your mouse pointer over the body of the pivot table in the…
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.
