Skip to main content
SheetTutor.
Pivot workshop

Original inputs · synthetic items

Follow the calculation. Keep the source.

Learn how named items, solve order and overlapping totals work on the same actual spreadsheet you can edit.

Teaching · read-only · Report!A1

Step 1 / 6Trace an original item to source records

Inspect
More

Original item intersections sum matching observations. Synthetic items retain the original source. Teaching is read-only; switch to Your turn to edit.

Items and source!K2 · (blank)
No formula applied

Preparing the actual calculated-item worksheet…

Correct invalid source/controls or explicitly restore modified helpers.

Literal item definitions on the actual worksheet
Report choices update the same literal cells
Visible product items
Visible region items
Complete actual calculated report and original-record result

Original source amount: 900. Visible total includes synthetic items and overlaps.

productEastNorthWestCombined regionsGrand total
CedarWaiting…Expected 220Waiting…Expected 0Waiting…Expected 60Waiting…Expected 280Waiting…Expected 560
HarborWaiting…Expected 0Waiting…Expected 120Waiting…Expected 0Waiting…Expected 0Waiting…Expected 120
LumenWaiting…Expected 250Waiting…Expected 110Waiting…Expected 140Waiting…Expected 390Waiting…Expected 890
Item ratioWaiting…Expected 0.88Waiting…Expected 0Waiting…Expected 0.42857142857142855Waiting…Expected 0.717948717948718Waiting…Expected 2.0265201465201463
Grand totalWaiting…Expected 470.88Waiting…Expected 230Waiting…Expected 200.42857142857142Waiting…Expected 670.7179487179487Waiting…Expected 1572.0265201465202

Current worksheet copies retain actual source formulas and cells. Native files carry calculated source facts, named item definitions and solve order. Desktop Excel rendering, refresh and edit/save have not been verified.