Challenge #98: SANTALYTICS 2017 - Part 2

[martinding]

I struggled to get the layout right, had to check the community threads for help, credit to Philip Mannering!

Spoiler

[grazitti_sapna]

Difficult Challenge. Required help for some of the elements.

[Kinga]

hi,

Please find my solution. I need some help from community to solve it.

Spoiler

[JamesCharnley]

Spoiler

Ended up going to war with my Alteryx crashing over and over on this one and limitations working with the reporting cells. For some reason the crosstab tool would blow up if set to concatenate instead of first despite not actually applying the aggregation. Leaving it here so I won't be sworn off reporting tools but I'm still pretty happy with how the outcome.

[Jean-Balteryx]

Here is my workflow !

[ahsanaali]

Spoiler

Spoiler

[kristiadiuisan]

Spoiler

[alacoume]

My solution:

[leonhekkert]

My solution to challenge 98. Although I have to say the generate rows part is heavily inspired by the solution that I saw from @LordNeilLord. 

Was really struggling why i have extra space after the fourth column but saw in the end that the tool with rank 157 had name which was too long.. :|

Spoiler

[CeliaC_Silje]

Workflow:

Spoiler