Challenge #8: Aggregate Consumer Purchases

[qb]

Baby's second challenge response. This was helpful cross-tab practice.
I don't like that I've filtered the dates by string, or how ugly the meal filter is, but I need to accept that sometimes "done" is better than "perfect". I'll learn better with time!

[David-Carnes]

Pretty standard fare.

Spoiler

[alexo]

I used a formula to generate flags for each meal type, then a summarize max (read: boolean AND), grouping by ticket id to find the ones that matched all three conditions.

[pengland17]

Hello!

Please find attached my solution to the challenge.

Spoiler

Solution

Many thanks,

Paul

[ExploreMore]

My solution

[RotesDB]

Spoiler

[ocasey]

Not the most direct way but only two extra steps!

[LukeG]

Spoiler

My Solution. I used the Contains() function to identify whether a row had (Pizza OR Burger) AND (Side AND Drink)

[Cbarker]

Just completed weekly Challenge #

Spoiler

8 

[eric_strein]

Solution attached.