Join Curt Frye for an in-depth discussion in this video Managing subtotals and grand totals, part of Excel for Mac 2011: Pivot Tables in Depth.
- [Voiceover] Excel PivotTables display your data…in as much more or as little detail as you prefer.…Pivoting and filtering the PivotTable changes…how the individual data elements are displayed.…But you can also position these subtotals…and the grand totals for rows and columns…to summarize your data as desired.…In this movie I will show you how to work with…subtotals and grand totals in a PivotTable.…My sample file is called subandgrand.…That is an Excel workbook you can find…in the Chapter 2 folder of your exercise files archive.…
This PivotTable has subtotals and grand totals.…You can see the subtotals for the year 2014 here…in cells B5 and C5.…For 2014, the Cambridge room generated $1,111,886 revenue,…and the Piccadilly room 1,214,733.…And if you look down in Row 18,…we'll see the same subtotal for the year 2015.…Grand totals, find the grand total for each row…and column, when you have them turned on.…
In this case we have the grand total in Column D.…The two subtotals for 2014 add up to 2,326,619.…And if you scroll down, in Row 18 you can see…
Author
Curt Frye
Released
8/17/2016- Creating a PivotTable
- Refreshing PivotTable data
- Managing totals
- Creating calculated fields
- Grouping PivotTable fields
- Sorting and filtering PivotTable data
- Printing PivotTables
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 6s
-
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables4m 15s
-
Creating a PivotTable2m 51s
-
Pivoting a PivotTable2m 58s
-
Configuring a PivotTable4m 12s
-
Managing PivotTables4m 16s
-
-
2. Summarizing PivotTable Data
-
Creating a calculated field3m 43s
-
Grouping PivotTable fields3m 26s
-
3. Sorting and Filtering PivotTable Data
-
Sorting PivotTable data2m 47s
-
-
4. Formatting PivotTables
-
Applying a PivotTable style2m 41s
-
Creating a PivotTable style3m 53s
-
-
5. Printing PivotTables
-
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: Managing subtotals and grand totals