1. Prepare a reporting table from related files
All 48 lines match 24 unique order keys. Filtering completed status yields 42 lines for 21 orders. Line value is quantity×unit_price_cents; no arbitrary fill should turn an unmatched order into completed activity.

2. Create PivotTables and compatible measures
April is 11 orders and EUR 600; May is ten and EUR 590. A line-row PivotTable count doubles orders. An order-grain intermediate sums each order’s lines once, then monthly counts are ordinary row counts.

3. Reconcile formulas and write a reporting note
Grand AOV is 1190/21≈EUR 56.6667. The unweighted mean of 600/11 and 590/10 is about EUR 56.7727, which is a different calculation. Exclude three cancelled orders and disclose the fictional source scope.
