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 #142: Life Certainties - Workflows, Death, and Taxes

JasonHu
8 - Asteroid

 

Spoiler
workflow.png

 

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-25 à 16.49.11.png
MikeLR
8 - Asteroid

Not yet skilled enough with macros to take the hard path

Spoiler
MikeLR_0-1603808602561.png

 

joshbennett
11 - Bolide
11 - Bolide

Here is my solution! As with most things in life, I chose the "hard path" for this solution. Unlike most things in life, I did so intentionally this time. It was tougher than I thought it would be to solve without Join / Crosstab / Transpose / Multi-Field Formula / Multi-Row Formula! 

 

Spoiler
Not using Transpose / Crosstab forced me to try a new tool in the reporting group I have not used much before: Arrange - and I am glad I did, as it is a pretty useful one!
joshbennett_0-1607461626674.png

 

"

Desmond
8 - Asteroid

My Solution (the hard way)

shyamraman
8 - Asteroid

I'll come back for the hard path!

Spoiler
challenge142.PNG

 

OwenBData
8 - Asteroid

Tough challenge!

Spoiler
OwenBData_0-1609259866799.png

 

JP_SDAK
8 - Asteroid

I don't know if I made it even harder by separating Individual from Joint salaries, but that and a macro are the way I did it without having to use joins.

 

Spoiler
JP_SDAK_3-1609305420582.png

 

JP_SDAK_2-1609305354316.png

 

KOON
8 - Asteroid

done

danettedavis
8 - Asteroid

not completely the easy way.. but done.