Pivot tables: total and count sales by store in Google Sheets

To make a pivot table in Google Sheets, click a cell in your data and go to Insert > Pivot table. In the Pivot table editor, add a text field such as Store under Rows and a number field such as Sales under Values, where it's summarised by SUM. To count the rows instead, change Summarise by to COUNTA.

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.

What you'll practise

Turn an orders log into sales by store in a few clicks: insert a pivot table, add Rows and Values, switch SUM to COUNTA, then re-cut it by category.

4 steps · 40 points · the cells outlined in gold below

pivot tables
Rows and Values
SUM vs COUNTA
Summarise by

The data

	A	B	C
1	Store	Category	Sales ($)
2	Cairns	Tents	4,860
3	Brisbane	Packs	2,315
4	Townsville	Apparel	1,742
5	Brisbane	Tents	6,280
6	Darwin	Packs	1,968
7	Cairns	Apparel	2,104
8	Brisbane	Apparel	3,457
9	Townsville	Tents	5,125
10	Darwin	Tents	3,890
11	Cairns	Packs	1,536
12	Brisbane	Packs	2,746
13	Townsville	Packs	2,083
14	Darwin	Apparel	1,377
15	Brisbane	Tents	7,014
16	Cairns	Tents	3,962
17	Townsville	Apparel	2,598
18	Brisbane	Apparel	1,829
19	Darwin	Packs	2,451
20	Townsville	Tents	4,307
21	Cairns	Apparel	1,718

Pivot tables: total and count sales by store in Google Sheets

What you'll practise

The data

This drill comes with the semester pass.