Uploaded August 2017 | Updated September 2026, 10 minutes ago

---

See how to calculate the single largest Customer Monthly Total from 81 customers over a 12-month period.
Alternative solution to Mike Girvin's solutions.
00:00 Challenge review
00:26 Mike's solutions!
01:30 My solution: dynamic & easy to explain/audit
01:48 Step 1: Helper column to truncate transaction date
02:10 Step 2: Helper column for every month
02:41 Step 3: Helper columns to calc sales per month & customer
03:33 Step 4: Calc the max of Step 3.
03:50 Review all three solutions.