From the course: Google Sheets: Pivot Tables
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Show and hide totals
- [Narrator] Pivot tables display your data in as much or as little detail as you prefer. Pivoting a pivot table changes how the individual data elements are displayed but you can also use totals to summarize your data as desired. In this movie, I will show you how to show and hide totals within a Sheets pivot table. My sample file is 01_07_Totals and you can find it in the chapter one folder of the exercise files collection. This workbook has two worksheets and I'm on the pivot table two sheet. This pivot table summarizes project data for four projects across the years 2016 and 2017. I have grand totals for the years of 2016 an 2017 in column F. So at the end of the row. And then I also have grand totals for each of my projects as you can see in worksheet row five. So I have grand total for the LV project in column B, for the MT project, it's in column C, and so on reading to the right. If I add another layer of organization in the rows area, then we will get a new set of subtotals…
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.
Contents
-
-
-
Arrange your data for use in a pivot table3m 18s
-
(Locked)
Create a pivot table2m 8s
-
(Locked)
Pivot a pivot table3m 41s
-
(Locked)
Edit a pivot table’s data source3m 19s
-
(Locked)
Change a value field’s summary operation5m 4s
-
(Locked)
Create a calculated field5m 7s
-
(Locked)
Show and hide totals3m 43s
-
-
-