We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #324: Totals and Subtotals

Robin_McIntosh
11 - Bolide
Spoiler
Robin_McIntosh_0-1656355978424.png

 

tammybrown_tds
8 - Asteroid

I solved two ways.  One that will only work if the incoming data doesn't change (i.e., no new countries or food items are added), and one that WILL work if incoming data changes.

 

Spoiler
tammybrown_tds_0-1656368190268.png

 

CHarrison
8 - Asteroid

My solution :)

CharlotteGuy
8 - Asteroid

Here is mine 

Jeremy
8 - Asteroid

Two ways - one absolutely avoid the obvious transpose -> crosstab solution and the second using the Crew macro to do this with no fuss.

Spoiler
2022-06-28_19-11-30.png
NiallJ
7 - Meteor

Effort

atcodedog05
22 - Nova
22 - Nova

My take on this

 

Spoiler
atcodedog05_0-1656500974107.png
Kamran1991
11 - Bolide

My solution:)

beccat
8 - Asteroid

Super helpful - and love that several people built this into a macro!  My solution with my table:

 

Spoiler
beccat_0-1656690299225.png

 

Timi8
7 - Meteor

 

Spoiler

Learned a tip....Always scroll down and check out all the options in the Crosstab as the Totals might be right there... Thank you for the challenge.

 

Timi8_0-1656775471860.png