Search

Close

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

" Running Total "

My solution attached.

Used a combination of sorting and multi row formula to allocate the inventory from the warehouse to the stores in the appropriate manner.

Done!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/

Screenshot 2023-09-08 160054.png

Hi! Here is my take :-)

Screenshot 2023-09-27 170817.png

hmmm

My thirty-fourth workflow! Done!

solution

Really didn't need to do a Macro, especially since I then had to debug it and figure out why things weren't joining properly, but hey, it gave the needed result.

Screenshot 2023-10-13 A.png

Macro

Screenshot 2023-10-13 B.png