Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Still new to Alteryx, so not as comfortable with Transpose/Crosstab. I took a stab at this (option A in the attachment) before consulting the solution files. Obviously, much simpler (and scalable) to tackle this using Transpose and Crosstab.