My solution is similar to others. The key thing I did was summarizing the data after the join operation with grouping by TicketID and Type and counting each type. I then created a crosstab (keeping the group by TicketID) and summing each type (it doesn't change any of the data) to create a single row for each TicketID. Using the logic in problem, I used a conditional formula that checked if the critical meal types were greater than 0 in count. If criteria met, 1, else 0. Then all that was left was summarizing to get the potential meal deals and total, followed by formula tool to calculate percentage.
I was unsure at first if nulls would create errors in the conditional formula. I split this part in two at first to see if there would be a difference between leaving nulls or using a multi-field formula to replace nulls with zero. Both methods matched results with target.
