Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAIt took me a while to figure out that i need to use 3 cross tabs to basically create 3 table and merge them together. The convention is very different from Power BI.
Two aspects I loved about this challenges was using a batch macro to create subtotal rows and using the dynamic rename tool to remove those annoying "Sum_ " prefixes from column headers!!!!
Enjoy fellow Alteryx peeps. 😊
Nice use of the imputation tools my friend!
Awesome data manipulation challenge!
I'm sure there's a better way!