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

maleu_ramos
7 - Meteor

Challenge 324? Completed it mate.

ddiesel
13 - Pulsar
13 - Pulsar

I solved this two ways:

 

Spoiler
One with one of my favorite CReW macros and one without:

Capture.JPG


  

 

Tony_Castillo
9 - Comet
Spoiler
Tony_Castillo_0-1655934350257.png

 

DataNath
17 - Castor

My solution to #324.

 

Spoiler
DataNath_0-1655937852749.png

 

ss0061933
5 - Atom

Learned to calculate row and column total and then combine it using UNION to create a table  

yueceyurt
7 - Meteor

done

dbrownsc
7 - Meteor

CReW Macros are a lifesaver.

 

Spoiler
dbrownsc_1-1655989240399.png

 

PhilipMannering
16 - Nebula
16 - Nebula

See attached,

 

Spoiler
PhilipMannering_0-1655990399789.png

 

Amol_Telore
11 - Bolide
Spoiler
Amol_Telore_0-1655993652554.png

 

Never knew we could add total rows/columns dynamically.. Thanks for posting this challenge.!!

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1656000089469.png

 

Simple but useful little reporting challenge!

 

Edit: Did not know there was a crew macro for that! Always nice to learn!