Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

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