ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

Challenge #14: Warehouse Distribution

karlhansen
9 - Comet

inserted the wrong image

karlhansen
9 - Comet
Spoiler
solution_14.jpg
amjadmanasra
8 - Asteroid

I cannot even imagine how to solve this with iterative macros :D

simple running total will do the job easily 

here is my solution (like many others before me )

I will try to do it with macro just for fun 

 

JoshuaB
Alteryx
Alteryx

Updating from my old profile

Joshua Burkhow | Chief Evangelist @ Alteryx | Follow me on LinkedIn and Twitter
mg46
8 - Asteroid

Might have to revisit this one once I upskill a bit in the macro arena.  This time around I solved without the macro, but I'm enjoying going through and learning from the other macro solutions!

 

Spoiler
mguarniere_0-1664561471734.png

 

Hemanth9773
6 - Meteoroid

The logic used in Multi-row Formula was Fentastic

_Viktoria_
8 - Asteroid

Solution

alisonpitt
11 - Bolide
Spoiler
challenge-14-macro-ap.pngchallenge-14-ap.png
igminto
8 - Asteroid

Here's my solution

NicolaMahood
8 - Asteroid
Spoiler
NicolaMahood_0-1665410768652.png

 

I didn't go down the Macro route for this one, but I found that the running total and a few calculations that I then removed with a select tool did the job.