Excel PivotTables display your data in as much or as little details you prefer.…Pivoting and filtering the PivotTable changes how the individual data elements…are displayed, but you can also position the subtotals and grand totals for rows…and columns to summarize your data as desired.…For example, in this PivotTable I currently have both Subtotals and Grand…Totals turned on so you'll see that for FirmA the subtotal for the year 2009…was 963, for FirmB the same subtotal for that year was 924, and we have a grand…total for that year of 1887, and you'll see a subtotal for each of the firms…and the grand total for 2010.…
And then at the bottom of the PivotTable, which I displayed by scrolling down…using my mouse's scroll wheel, you'll see that we have a grand total for FirmA of…1924, FirmB of 1729, and a grand total for both of 3683.…Now, I'd like to show you how to change how subtotals and grand totals are…displayed, so I'll scroll back up so you can see my change more clearly.…Now after clicking any cell inside the PivotTable I can go up to the Design…
Author
Released
4/19/2011- Formatting data for use in a PivotTable
- Connecting to an external data source
- Refreshing a data source
- Adding, removing, and positioning subtotals and grand totals
- Creating a calculated field
- Grouping PivotTable fields
- Clearing and reapplying PivotTable filters
- Applying field styles
- Formatting cells
- Creating a PivotChart
- Printing PivotTables and PivotCharts
- Creating relationships between tables in a PowerPivot model
- Using the DAX language for advanced summaries in PowerPivot
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2010: Tips, Tricks, and Shortcuts
with Dennis Taylor3h 43m Intermediate -
Excel 2010: Macros
with Dennis Taylor2h 44m Intermediate -
Excel 2010: Charts
with Dennis Taylor3h 38m Intermediate -
Excel 2010: Financial Functions
with Curt Frye2h 18m Intermediate
-
Introduction
-
Welcome52s
-
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables4m 2s
-
Creating a PivotTable4m 20s
-
Pivoting a PivotTable3m 47s
-
Configuring a PivotTable3m 22s
-
Managing PivotTables3m 26s
-
-
2. Summarizing PivotTable Data
-
Creating a calculated field2m 27s
-
Grouping PivotTable fields3m 17s
-
3. Sorting and Filtering PivotTable Data
-
Creating a custom sort order2m 48s
-
Formatting slicers3m 43s
-
4. Formatting PivotTables
-
Creating a PivotTable style4m 37s
-
5. Applying Conditional Formatting to PivotTables
-
6. Creating and Manipulating PivotCharts
-
Creating a PivotChart3m 29s
-
Pivoting a PivotChart3m 5s
-
Filtering a PivotChart3m 45s
-
Formatting a PivotChart3m 35s
-
Changing a PivotChart layout3m 14s
-
-
7. Printing PivotTables and PivotCharts
-
Printing a PivotTable4m 2s
-
Printing a PivotChart1m 55s
-
-
8. Manipulating PivotTables Using Macros
-
Running a macro5m 57s
-
9. Getting Started with PowerPivot
-
Introducing PowerPivot2m 8s
-
Importing PowerPivot data3m 14s
-
Managing table columns4m 1s
-
-
10. Working with DAX Expressions
-
Introducing the DAX language2m 58s
-
Using DAX operators4m 44s
-
Surveying DAX functions2m 40s
-
Using aggregate functions4m 24s
-
-
Conclusion
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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: Adding, removing, and positioning subtotals and grand totals