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.