We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Mine doesn't tie out either. It's also not as efficient as I feel like it could be. Going to check out others solutions after posting this:
Had the same issues as everyone else in matching the output. If you want to see me build it "live" then watch my video here: https://www.dataprepsolutions.com/2020/02/alteryx-weekly-challenge-203-build.html
I hit a bit of a wall on this after I had transposed the data. I was trying to summarize the data and after a few failures, I had to borrow ideas from other users. Then, I quickly realized I had forgotten to consider the Multi-Row Formula tool to prepare the data for grouping and aggregating.
I have forgotten about the Multi-Row and Multi-Field formula tools on numerous occasions and it would've saved me a decent amount of time and headaches.
Now I'm making sure to favorite these tools in my toolbar for future workflows!