Task 1 of 1
Build a PivotTable in F1: cities in rows, products in columns, the number of deals.
Lesson theory
If you put a field in both Rows and Columns, you get a cross-tab: cities down the side, products across the top, and a total where they meet.
The Count operation counts how many records fall into a cell, that is, how many deals there were.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page