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

binuacs
17 - Castor
Spoiler
binuacs_0-1657129615904.png

 


 

ByrnesR
5 - Atom

My solution

gabrielpereira
8 - Asteroid

Solution

rrahu07
8 - Asteroid

My Solution: 

rrahu07_0-1657141642779.png

 

DataNath
16 - Nebula

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
6 - Meteoroid

Hi,

 

Here is my solution!

Tried my first challenge and it was fun! :)

 

 

tanyafischer
8 - Asteroid

solved :)

PhilipMannering
15 - Aurora
15 - Aurora

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.