Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI joined the both source data to vlookup the food types and then filter by dates to exclude anything before july 1 as per Hint.
Then using cross tab arranged the order list per ticket wise and then with help of filter tool filter tickets having required food types.
Finally get a count of potential and total and generate percentage by formula tool and also limiting to 6 decimals
Simple Solution : )