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 #326: Totals and Subtotals Part 2

binuacs
20 - Arcturus
Spoiler
binuacs_0-1657129615904.png

 


 

ByrnesR
5 - Atom

My solution

gabrielpereira
8 - Asteroid

Solution

rrahu07
8 - Asteroid

My Solution: 

rrahu07_0-1657141642779.png

 

DataNath
17 - Castor

My solution to #326.

 

Spoiler
DataNath_0-1657147852408.png

 

nkinsey
8 - Asteroid

Here's my solution. Not as dynamic as it probably could be, but it gets to the output file.

Spoiler
nkinsey_1-1657164841914.png

 

NaomiMariaThomson
7 - Meteor

Hi,

 

Here is my solution!

Tried my first challenge and it was fun! :)

 

 

tanyafischer
8 - Asteroid

solved :)

PhilipMannering
16 - Nebula
16 - Nebula

My totals below,

 

Spoiler
PhilipMannering_0-1657181197315.png

 

LiuZhang
9 - Comet
Spoiler
326.png

To preserve the order, feel options:

1: could do with union separate workflows, but it will have more duplication on some tools.

2: use select records, but it only returns in the ascending order, so need to use multiple to union the results

3: Create dummy ID field along the way

As the table structure is not standard format with subtotal/total in them, didn't bother to change the order here.