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
Wasn't clear whether "id" was specific to the athlete so I added a check to make sure that an athlete didn't compete in multiple sports (looking at name, dob, height, and weight). There were bad totals based on adding a number to a null in some rows.
Spoiler
I noticed that the "Total Row" function in Crosstab ignores nulls. I think this is because it totals the values before pivoting, so the null values haven't been created yet.
