About this lesson

Pivot tables: columns, % of total and filters in Google Sheets

To split a pivot table across the top in Google Sheets, add a field under Columns in the Pivot table editor. To show shares instead of amounts, change the value's Show as to % of row, % of column or % of grand total. To show only some items, add a field under Filters and pick them in its Status list. Google Sheets pivot tables update by themselves when the data changes.

Using Excel? Do this lesson in Excel.

Pivot tables need a big screen and a mouse. This lesson works on a phone, but it's hard going, so jump on your computer if you can.