We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #326: Totals and Subtotals Part 2

kceleven11
8 - Asteroid
Spoiler
kceleven11_0-1657049999865.png

 

Kenda
15 - Aurora
15 - Aurora
Tony_Castillo
9 - Comet
Spoiler
Tony_Castillo_0-1657052189049.png

 

TonyAndriani
8 - Asteroid

@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
16 - Nebula
16 - Nebula

My solution.

 

 

Spoiler
 
AkimasaKajitani_1-1657069541722.png

 

 

 

 

TurboToad
8 - Asteroid

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

 

Spoiler
TurboToad_0-1657075332108.pngTurboToad_1-1657075364060.png

 

 

ahsanaali
8 - Asteroid

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!