In order to compare business data, you'll first have to display them inside of your PivotTable. Breaking the data into yearly or quarterly summaries will help you draw useful inferences from it. PivotTables in Microsoft Excel 2013 allow you to add more than one value to your data field and summarize each as necessary. In this online training video, you'll learn about summarizing more than one data field and changing the order of data fields.
So far in this course, all of the PivotTables I have shown you have had a single…data field in the values area of the PivotTable.…In other words, the body of the PivotTable has only contained a single type of…data, such as number of customers acquired, sales, and so on.…In this movie, I will show you how to add a second data field to the Values area…of your PivotTable.…I'll use the MoreThanOne sample file, which you can find in the Chapter02…folder of your Exercise Files archive.…This PivotTable contains data about new customers acquired for each of four…regions for the years 2012 and 2013, with the yearly data broken down by quarter.…
If you look over the PivotTable Fields pane, you can see that I have a fifth…field, Sales, which is not currently displayed in the body of the PivotTable.…Now, Sales data takes on the same role as customers,…so I could pull out the Customers field, and put Sales in in its place,…but instead of what I'd like to do is display both of them in the body of the PivotTable.…
Author
Curt Frye
Released
4/11/2013- Creating a PivotTable
- Summarizing multiple data fields
- Managing subtotals and grand totals
- Grouping PivotTable fields
- Filtering with selections, rules, slicers, and search filters
- Applying PivotTable styles
- Formatting cells
- Creating PivotCharts
- Enabling PowerPivot
- Using DAX operators
- Visualizing data with matrices, cards, and tiles
- Building charts and maps
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 2s
-
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables3m 14s
-
Creating a PivotTable2m 37s
-
Pivoting a PivotTable3m 13s
-
Configuring a PivotTable3m 17s
-
Managing PivotTables3m 48s
-
-
2. Summarizing PivotTable Data
-
Grouping PivotTable fields2m 40s
-
3. Sorting and Filtering PivotTable Data
-
Sorting PivotTable data3m 41s
-
Creating a custom sort order3m 52s
-
Formatting slicers3m 7s
-
-
4. Formatting PivotTables
-
Applying a PivotTable style2m 36s
-
Creating a PivotTable style4m 27s
-
-
5. Applying Conditional Formats to PivotTables
-
6. Creating and Manipulating PivotCharts
-
Creating a PivotChart2m 34s
-
Pivoting a PivotChart2m 24s
-
Filtering a PivotChart2m 48s
-
Formatting a PivotChart3m 38s
-
-
7. Printing PivotTables
-
Printing a PivotTable2m 53s
-
Printing a PivotChart1m 14s
-
-
8. Manipulating PivotTables Using Macros
-
Running an Excel macro4m 4s
-
9. Starting with PowerPivot and the Data Model
-
Introducing PowerPivot4m 32s
-
Importing PowerPivot data3m 24s
-
Managing table columns3m 21s
-
10. Introducing Data Analysis Expressions (DAX)
-
Introducing the DAX language2m 29s
-
Using DAX operators4m 35s
-
Surveying DAX functions2m 35s
-
Adding calculated columns2m 11s
-
Adding calculated fields3m 7s
-
-
11. Visualizing Power View Data Using Matrices, Cards, and Tiles
-
Starting out with Power View2m 16s
-
Creating a card3m 30s
-
Creating a tile3m 18s
-
Filtering Power View objects3m 31s
-
-
12. Visualizing Power View Data Using Charts and Maps
-
Creating a pie chart2m 7s
-
Creating a line chart2m 40s
-
Creating a map2m 31s
-
Creating chart multiples2m 38s
-
Conclusion
-
Next steps54s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Summarizing more than one data field