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 #292: It's about Pivoting, Prepping and Reporting!

coracai
8 - Asteroid

Here is my solution. 

AlteryxAlexB
Alteryx
Alteryx
Spoiler
AlteryxAlexB_0-1638348212272.png

 

benjamin_feuchter
8 - Asteroid
Spoiler
benjamin_feuchter_0-1638970815589.png

 

Erin
9 - Comet
Spoiler
Good news is I did it - but cannot figure out where the "Header tab" is in the configuration of the basic table to Highlight the headers Blue. I basically created the same column rule for each field and applied to Headers only which is not efficient. 

BronzeFox_0-1640197112744.png

 

ggruccio
ACE Emeritus
ACE Emeritus

Nice refresher on the reporting tools - although....

 

Spoiler
I manually created the subtotals and grand totals and then manually color-coded them in the Table tool - wondering if others tried a Pivot inside the tool?
ggruccio_0-1640728636588.pngggruccio_1-1640728665549.png

 

 

atcodedog05
22 - Nova
22 - Nova

Here is my take on it

 

Spoiler
atcodedog05_0-1640887701844.png

 

geoff_zath
Alteryx
Alteryx
Spoiler

geoff_zath_0-1640896329061.png

 

davidhardister
8 - Asteroid

davidhardister_0-1641153350221.png

 

derekbelyea
12 - Quasar

derekbelyea_0-1641435397851.png

 

OllieClarke
15 - Aurora
15 - Aurora

Here's my solution:

Spoiler
OllieClarke_0-1641486539779.png