Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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 #326: Totals and Subtotals Part 2

kceleven11
8 - Asteroid
Spoiler
kceleven11_0-1657049999865.png

 

Kenda
16 - Nebula
16 - Nebula
Tony_Castillo
9 - Comet
Spoiler
Tony_Castillo_0-1657052189049.png

 

TonyAndriani
9 - Comet

@Kenda Thanks. That explains why it didn't work when I tried your workflow. I played a bit with custom functions, but try to avoid them because they require that you load a custom XML or DLL file in the FormulaAddIn folder on any machine that will run the workflow.

Kpeter02
6 - Meteoroid

Answer

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

 

Spoiler
 
AkimasaKajitani_1-1657069541722.png

 

 

 

 

TurboToad
10 - Fireball

My solution :). I see those Field names and sub totals and think CT!

 

Spoiler
TurboToad_0-1657075332108.pngTurboToad_1-1657075364060.png

 

 

ahsanaali
11 - Bolide

The great reunion :-)

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1657089408315.png

 

NW_Cms
5 - Atom
Spoiler
NW_Cms_0-1657107997656.png

 

Thanks for another challenge!