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 #324: Totals and Subtotals

kaiserj
8 - Asteroid

😀

DanielvanLeuzen
8 - Asteroid

my solution

caltang
17 - Castor
17 - Castor

Done!

 

Spoiler
Screenshot 2023-07-11 192645.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
bdoni001
8 - Asteroid

Here is my solution to the problem.

 

Best regards,

Bona

 

Spoiler
Challenge_324.PNG
Pilsner
10 - Fireball

My Solution:

Spoiler

324.png

tristank
11 - Bolide

I'm hoping there was a less hacky approach to this but I'm doubtful.

 

Spoiler
Screenshot 2023-07-26 202630.png

 

ed_hayter
12 - Quasar
Spoiler
Lazy Solution this time - used the Crew Macro to Add Totals and then Data-Clean to replace Nulls with 0, some formatting in the table report tool to get output.
Challenge 324 WF Image.png

Rana_Kareem
9 - Comet
Spoiler
Challenge 324.png

mithily
8 - Asteroid
Spoiler
easy totals and unions
Computernerd
8 - Asteroid

I did it two ways. The second way is the easiest but requires a macro.