I used formula tool in order to check if ticket ID meets the condition
A couple of gotchas in this one!
When the question says "since June 2013" it doesn't mean, since the beginning of June 2013.
it means "from 1st of July 2013 onwards", or "after the end of June 2013".
I tried to solve this first with a RegEx tool but wasn't able to figure out how to do the OR logic.
The way to structure this is:
Step 1 - build a fact table. That's just the transactional PoS data, with a few extra columns
Step 2- we can then Cross Tab to "collapse" the transactions and sum to each Transaction, where each Transaction contains (Pizza OR Burger) AND Side AND Drink.
Then it's just case of adding across.