You have inherited a report whose totals look reasonable. The business owner needs a definition that survives a change in the source rows. Work through the tasks on a fresh fixture, inspect the output after each change, and keep the report population consistent. A correct title or a matching total from one query is insufficient. Each step checks the saved definition or the resulting groups.
Use the field picker and the generated result together. The warehouse contains repeated customer keys, orders with several items and missing values. Those rows make a plausible-looking total insufficient evidence. Run the requested definition, inspect its grain, and use the feedback to locate the mismatch. Every dataset here is fictional.
Preserve orders without a matched customer.