Challenge 1: Building a Region/Category/Sales Pivot Table — Solution Walkthrough

Steps:
  1. Click inside the source data (Region, Category, Sales).
  2. Data > Pivot Table > Insert.
  3. In the Layout dialog: drag "Region" from Available Fields into
     Row Fields; drag "Category" into Column Fields; drag "Sales"
     into Data Fields (defaulting to Sum, since Sales is genuinely
     numeric).
  4. Click OK — the Pivot Table now appears on the sheet, one row per
     Region, one column per Category, each cell showing that
     Region+Category combination's total Sales.

Which dialog this was configured in:

The entire layout — all three field placements — was configured
inside the single Layout dialog BEFORE clicking OK. Nothing appeared
on the actual worksheet until every field was already placed and the
dialog was confirmed.

What had to be done differently compared to Excel Fundamentals Chapter 9:

In Excel, the same three fields would be dragged one at a time into
a live, docked Fields panel (Rows, Columns, Values), with the actual
PivotTable on the sheet updating after each individual drag — you'd
see the grid start to take shape as Region alone was added, then
reshape further once Category was added, then populate with real
numbers once Sales was added last. In Calc, none of that intermediate
visual feedback exists — all three fields were placed inside the same
static dialog with no partial result visible anywhere, and the
completed Pivot Table only appeared all at once, the moment OK was
clicked.

WHY THIS WORKS AS AN ANSWER
------------------------------
This directly demonstrates this chapter's own central distinction: the
underlying four-role model (something for rows, something for
columns, something aggregated) is identical, but Calc requires
committing to a full configuration before seeing any result, whereas
Excel reveals the result incrementally as you build it.