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 #63: Data Preperation Using Pivot Tools

Maxine
8 - Asteroid

My solution to Challenge 63

CandiceDB
Alteryx
Alteryx

My solution:

 

Spoiler
CandiceDB_0-1637936213494.png

 

Chloeli
5 - Atom

Spoiler

juliabarale002
8 - Asteroid

:Transpose::crosstab:

fvojtesek
8 - Asteroid

My solution.

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here is my solution:

LiuZhang
9 - Comet
Spoiler
63.png
summit_view
8 - Asteroid

I recalculated the totals column since I didn't like how the desired output shows zero if the outside - point of sale column is missing.

 

ocean_odyssey_0-1639678736155.png

 

geoff_zath
Alteryx
Alteryx
Spoiler

geoff_zath_0-1639782036437.png

 

Gem
9 - Comet

This one was really challenging for me!