Challenge #8: Aggregate Consumer Purchases

[ChrisMelck]

I love completing a challenge and then looking at how other people used different tools to get to the same solution. While I am still learning I just try to get to the right answer, but as time goes by and data sets get bigger - getting to the right answer faster will be the challenge.

[papalow]

A fun challenge.  

[rslopez2]

Thanks for the Challenge! 2nd overall challenge attempt, and the first solution I was able to solve accurately start to finish without needing to google any alteryx "how-to" concepts and rely on the awesome community posts to get me to the end! 

Took a bit different approach Using the Find and Replace tool to append the "type" to the ticket orders then used formula tool to create a flag for the higher level categories vs. the multiple Joins approach in the posted solution. 

[cplewis90]

Spoiler

My solution

[dicky5150]

Another challenge completed, bit chunkier than most probably but it does the job !!

[nikolaskardasis]

Spoiler

[zoingz]

Attached is my solution

below is the general workflow process

[IJReed]

[rachelgatto]

Done!