Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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 #324: Totals and Subtotals

kaiserj
8 - Asteroid

😀

DanielvanLeuzen
9 - Comet

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
pilsworth-bulien-com
13 - Pulsar

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
13 - Pulsar
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.