Challenge #8: Aggregate Consumer Purchases

[Hjardine]

Spoiler

I needed to merge each row containing the same Ticket ID into one row in order to see which ones contain Burger or Pizza and Drink and a Side. I did this by using the summarize tools to group by each ticket id, then concatenated by type. I then filtered for those ticket id's that contain Pizza or Burger and Drink and Side. 

[shub123]

Hi ,

Please have a look for the solution of given challenge.

[mcazare]

Mine is a little longer, 

Note that my total is off by 10 because i filtered out "Soup"

[Winning_Culture]

Spoiler

Didn't manage to do with cross-tab, but the result is the same.

Hurrah!

[NichWhit]

Solution:

[TarunDeep]

Challenge text is somwhat different from the solution, but looking at some comments, picture was clear.

Tried to make it simple so used, filters and summarize tools. 

[WestonProhaska]

Solved it a little different than some others, could probably clean it up and use less tools, but this was a fun short little exercise. 

Spoiler

[Trumble_dup_334]

My approach was correct, although slightly different than the solution in the end, but couldn't get the correct potential meals number. Go there in the end though by hard coding a flag against each of the 4 types, and changing the formula. Could be much slicker, and I like the original solution approach of adding the 2nd lookup table to treat the two types as FOOD, makes it much smarter. 

[Nezrin]

Think this belongs to an intermediate category - started using lot more tools to arrive at the solution. but thanks for all the spoilers - helped to arrive the solution through an optimized set of tools