One source · independent Values
Keep the money. Show its share.
Add another Amount field to this real worksheet. Teach with the actual cells, then unlock the same workbook to try your own values.
Teaching · read-only · Report!A1
Step 1 / 6Read the original amount once
Preparing the Values worksheet…
Check actual source/Values cells, or explicitly repair edited calculation helpers.
Included records: of 12. Previous valid report.
Inspect each instance’s raw numerator and denominator
| Instance | Row | Column | Raw | Denominator | Displayed | Formula cells |
|---|---|---|---|---|---|---|
| Revenue | Cedar | 2026-01 | 240 | — | $240.00 | I61 ← I116 |
| Revenue | Cedar | 2026-02 | -20 | — | -$20.00 | J61 ← J116 |
| Revenue | Cedar | 2026-03 | 60 | — | $60.00 | K61 ← K116 |
| Revenue | Cedar | Grand total | 280 | — | $280.00 | L61 ← L116 |
| Revenue | Harbor | 2026-01 | 0 | — | $0.00 | I62 ← I117 |
| Revenue | Harbor | 2026-02 | 90 | — | $90.00 | J62 ← J117 |
| Revenue | Harbor | 2026-03 | 30 | — | $30.00 | K62 ← K117 |
| Revenue | Harbor | Grand total | 120 | — | $120.00 | L62 ← L117 |
| Revenue | Lumen | 2026-01 | 50 | — | $50.00 | I63 ← I118 |
| Revenue | Lumen | 2026-02 | 200 | — | $200.00 | J63 ← J118 |
| Revenue | Lumen | 2026-03 | 250 | — | $250.00 | K63 ← K118 |
| Revenue | Lumen | Grand total | 500 | — | $500.00 | L63 ← L118 |
| Revenue | Grand total | 2026-01 | 290 | — | $290.00 | I64 ← I119 |
| Revenue | Grand total | 2026-02 | 270 | — | $270.00 | J64 ← J119 |
| Revenue | Grand total | 2026-03 | 340 | — | $340.00 | K64 ← K119 |
| Revenue | Grand total | Grand total | 900 | — | $900.00 | L64 ← L119 |
Axes retain the complete source members. An empty Average stays blank; dividing a nonblank value by zero returns #DIV/0!. Each Average margin uses its own original records. This worksheet accepts up to 50 records, 50 row members, 12 column members and four Values.
Native copies carry every source record and independent Values metadata. Recalculate Source and refresh the Pivot after native edits; desktop Excel refresh, edit and save remain unverified.
Query an explicit value caption
This query lab resolves visible instance captions. Use the current row or column field names with literal items; an Amount alias does not choose between value instances. Blank Average queries return zero, while displayed empty averages stay blank.