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!
Here is my solution. I think the trick is to clean first, then union and join the data. Also if you know pivot functions then it would be very smooth for you.