Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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
8 - Asteroid

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