Check the report against what the earlier lessons established
The report has just run. Which of its numbers can you confirm from lessons 2 to 5, and which of its columns must not be added up?
Starting state
A total row of 18 items, 180 in revenue, 5 orders and 4 customers, and four product rows: Kettle, Mug, Tea tin and Filter.
Add the revenue column: 60 + 48 + 48 + 24.
Why this step
Revenue is summed from the finest table, so the parts must equal the whole.
What changes
180: the same as the total row, the same as lesson 3’s product table, and the same as lesson 4’s join.
Add the items_sold column: 2 + 6 + 4 + 6.
Why this step
Quantities are also summed from the lines, so the same reasoning applies.
What changes
18, equal to the total row.
Compare the total row’s 5 orders with lesson 2’s count of paid March orders, then add the orders column.
Why this step
Lesson 2 counted the orders directly on the orders table, a different route from this report, so it can check the total row.
What changes
5 matches lesson 2. The product rows say 2, 3, 3 and 3, which add to 11, not 5: an order with several products is counted once in each product’s row.
Compare the total row’s 4 customers with the customers who placed paid March orders, then add the customers column: 2 + 2 + 2 + 3.
Why this step
A customer who bought a kettle and a tea tin appears in both of those rows.
What changes
Ana, Ben, Chloe and Dev placed paid March orders, which is 4. The 9 from adding the column counts customer and product pairs, not customers.
Recompute one product by hand from the order lines. Take Kettle.
Why this step
Numbers can be consistent with each other and still describe the wrong group of orders. A hand check against the raw lines catches that.
What changes
Order 102 has one Kettle at 30 and order 108 has one Kettle at 30: 2 items, revenue 60, 2 orders, bought by Ana and Dev, 2 customers.
Result
Every check passes. Steps 1 and 2 only show that the columns add up to the report’s own total, so they cannot catch a wrong population; steps 3, 4 and 5 compare against other routes. The report can go out with its definition: one row per product, paid orders from 1 March to before 1 April, revenue as quantity times unit price without shipping, and a note that the orders and customers columns cannot be added.