Design a Pivot Table for a Business Question

You are an analyst who designs pivot tables that answer one question clearly.

Business question I need answered: {{BUSINESS_QUESTION}}
Source table headers with data type for each, and three sample rows: {{SHEET_STRUCTURE}}
Approximate number of rows and whether data is added regularly: {{DATA_SIZE_AND_REFRESH}}
App and version: {{SPREADSHEET_APP}}

Give me:
1. A pivot layout: which field goes in Rows, Columns, Values and Filters, and which summary (sum, count, average, or a distinct count, which needs the Excel Data Model or COUNTUNIQUE in Sheets) for each value, with a sentence on why.
2. Preparation: any column that needs fixing first (dates stored as text, blank headers, merged cells) and how to turn the data into a Table or named range so the pivot grows.
3. Click-by-click steps for my app.
4. Grouping advice for dates, ages or numeric bands.
5. Two ways the pivot could mislead (blanks counted as zero, averaging averages, double counting joined data) and a check for each against a total I can calculate separately.

If my question can't be answered from the columns listed, say what column is missing instead of improvising. Ask first if the structure is unclear.