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
9 - Comet

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