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

Keppatawn
8 - Asteroid
Spoiler
Keppatawn_0-1670215537517.png

 

Carolyn
12 - Quasar
12 - Quasar

Attached. I didn't realize Cross Tab had a Total option - I didn't realize I could scroll down in the "Method for Aggregating Values" area 😳  I've been doing it with the Summarization Tool and a Union (which isn't bad, but this will be easier in certain cases). 

Sashikumar
8 - Asteroid

My Solution.

Spoiler
ch324.PNG
StanleyKinnok_Chan
8 - Asteroid

It would be easy if you know the option of crosstab. If not, we can use summerize and union to create the row sum instead

sreekanthac
8 - Asteroid

My solution attached.

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

 

Spoiler
Weekly_Challenge_324.JPG
leonhekkert
8 - Asteroid

My solution.

 

Spoiler
Challenge_324.png
CammyPhillips
8 - Asteroid
Spoiler
CammyPhillips_0-1672828219735.png

 

longyanChen
8 - Asteroid

hi

Sunil_bs
7 - Meteor

Sunil_bs_0-1672942549034.pngSunil_bs_1-1672942570047.png