About this lesson

PivotTables: columns, % of total, refresh and filters

To split a PivotTable across the top in Excel, drag a field into the Columns box. To show shares instead of amounts, open Value Field Settings > Show Values As and pick % of Row Total, % of Column Total or % of Grand Total. To show only some items, drag a field into Filters and pick them from the drop-down above the pivot. A PivotTable doesn't update when its data changes: right-click it and choose Refresh.

Using Google Sheets? Do this lesson in Sheets.

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.