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 #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.