Challenge #8: Aggregate Consumer Purchases

[Thableaus]

Challenge #8, done.

Spoiler

Cheers,

[AdamBiggs]

Got there in the end :-) 

[alex2017]

My solution is attached.

[TonyA]

I followed the approach a few people used of concatenating the items instead of building a pivot. I'm wondering if it is more efficient to scan strings or pivot a table one or more times. Also, I replaced Pizza and Burger with the string Main in the 39-row lookup table before starting. This avoided have to test thousands of rows for Pizza or Burger later on. I also took the opportunity to play with Dynamic Replace. This probably wasn't the most efficient choice but I was curious about the tool and this seemed a good chance to try it out. 

Spoiler

[MichaelEvans]

Completed Challenge#8

[DavidHa]

Challenge 8 complete. 

[manion72]

thanks!   : )

[FeedMeData]

Attached my solution!

[robert-headington]

Here is my solution for challenge 8

[kmania]

My solution attached. I was a bit confused with dates. Initially I also included June 2013 as I was reading instructions inside the workflow and it still says "since June 2013".  Then I realized it has been changed in the post to "since July 1, 2013" so finally I got the same results as in the output.