Challenge #8: Aggregate Consumer Purchases

[LandonG]

My solution!

[SGolnik]

It is really interesting to see how I differed from the proposed solution on this one. Instead of a second look up table, I chose the multi-row formula field

[wanjum]

Solution attached.

 

[jasperlch]

Solution attached.

[MBark]

Finally utilized the crosstab tool. 

[aclaxton]

Had a small hiccup in my formula trying to put both Pizza and Burger in one !IsNull(), which counted 59 cases where both were null for some reason.

Spoiler

[blairmbailey]

Solution attached - thanks!

[servingmosthigh]

Mine is very similar to others, but just wanted to post :)

[NurulShi12]

Solution attached. My approach is a little different than the solution, which what makes Alteryx so interesting! So many different ways to answer a single question!

[michalsicak]

this was a great challenge!

Spoiler