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

dkungu
8 - Asteroid

my solution324.png

mgaronson
11 - Bolide
Spoiler
Challenge 324 Workflow Pic.png


 Method 1 - Not as flexible as using crosstab (Method 2). Method 1 - hard-coded countries. Method 2 - flexible if new countries added.

asultanov
8 - Asteroid
Spoiler
Screenshot 2024-01-25 121811.png
Rob-Silk
8 - Asteroid

Solution attached below - nice to have more of a play around with the Dynamic Rename tool:

 

Spoiler
challenge_324a_RS_screencap.PNGchallenge_324b_RS_screencap.PNG
YadTheTabLad
8 - Asteroid

image.png

Danny
7 - Meteor
 
Spoiler
Spoiler


Screenshot 2024-02-06 170442.jpg

Sivashankaran
7 - Meteor

PFA for the solution file.

 

Thanks,

Siva

brycegrathwohl
7 - Meteor

Complete-BG

Data_Tabs
7 - Meteor
Spoiler
 Spoiler Screenshot 324.png

 

lwolfie
10 - Fireball

That was a quick one.