PivotTables: total and count sales by store

To make a PivotTable in Excel, click a cell in your data, go to Insert > PivotTable and choose where to put it. Then tick fields in the PivotTable Fields pane: a text field such as Store goes to Rows and a number field such as Sales goes to Values as a Sum. To count the rows instead, open Value Field Settings and pick Count.

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.

What you'll practise

Turn an orders log into sales by store in a few clicks: insert a PivotTable, drag in Rows and Values, switch Sum to Count, then re-cut it by category.

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

PivotTables
Rows and Values
Sum vs Count
Value Field Settings

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

PivotTables: total and count sales by store

What you'll practise

The data

This drill comes with the semester pass.