Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Solved! My first thought was an iterative macro but since this is marked as Basic/Core, I went with a more Basic/Core solution :)
I think the wording of this challenge is a bit more confusing than intended. Once I started analyzing the output, it became clearer. Either way, great chance to practice multi-row formulae!
Great challenge 😊
Figured it would be interesting to try to avoid an iterative/batch macro....
Spoiler
My Image uploads are still bugged, but i was able to leverage a multi-row formula to do the calculations after pivoting. Likely not the way I would do it in a practical setting and I would typically opt for an iterative macro.
