Challenge #8: Aggregate Consumer Purchases

[LailaBene]

Great challenge!

[phottovy]

There is probably a way to do this in fewer steps but here is my solution.

[Hannah_Lissaman]

My solution :)

[Reesetrain2]

Hello,

I have attached my solution.

-The first one is not that clean, as I was trying for a long time to figure out why I could not get the correct total.

-I discovered that it was due to two items: the join and the sort date.

-The sort date was off, as you have to use July 1st to get the correct amount of transactions.

-The join does kick out some records due to duplicates due to their being three yes of sides (Soup, Salad or just side)

-The second method uses the Cross Tab method as it gets the correct amount.

-Please let me know what you all think.

-Cheers!

Matt

Spoiler

[Greg_Murray]

Spoiler

Solution attached

[cbraaten]

Not sure I have the most efficient workflow, but I got the desired results. Excited to look at how other's solved this challenge.

[Shaun_Rheeder]

My solution. Get's the job done and doesn't seem too inelegant/

[karenschuele]

My solution for challenge 8

[Etienne]

My solution for this challenge #8