Report each group share of net units
Your goal: Make the grand-total denominator explicit, retaining signed returns, missing intersections and a zero-net state.
Full task requirements
Enter one formula in G5. Use only Posted rows. If their signed grand sum is zero, return No net units in one cell. Otherwise return an empty-text corner, sorted channel headings and sorted region rows. Each observed intersection is its signed sum divided by the same grand signed sum; a missing intersection is empty text. Return decimal proportions, no row or column totals. Shares may be negative or exceed one.
Posted orders and returns; draft and void rows excludedChoose every Posted record
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 |
Step 1 of 8
Choose every Posted record
Rules for this step
Compare the whole status with Posted without letter case. Spaces are literal. Include matching negative and zero rows; duplicate labels do not merge physical records.