Cross-tabulate posted order means
Your goal: Build a region-by-channel mean report whose row, column and grand means use the original records.
Full task requirements
Enter one formula in G5. Use only Posted rows. Sort regions and channels ascending. Return an empty-text corner, channel headings, one mean-units row per region, a final Total column and a final Total row. Calculate each intersection and each total from its own original posted observations. A missing region/channel combination is empty text; a posted zero is numeric zero. If no row is Posted, return No posted records.
Posted orders and returns; draft and void rows excludedSelect the posted observation population
Posted source records define both axes, every intersection and every total mean.Scroll the worksheet vertically for later source rows and horizontally for later columns.
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 |
Step 1 of 5
Select the posted observation population
Rules for this step
Select identifiers in A for every Posted record. Draft and Void records do not define axes or averages. Keep repeated orders, signed units and numeric zero observations.