hi
I have a large selection of data from a meal deal promotion. To activate the promotion, you had to buy 1 item from 5 different 'courses' - a salad/sandwich, a savoury snack, a sweet snack, water, and a bag. The bag has to be included.
I can easily see what were the most popular products selected, but i need to work out what the most popular combinations were.
At present i have a table that looks a bit like this;
| Unit | Date | Time | Product |
| Lawn Larder | 3/7/23 | 11:30:00 | G&B Chocolate |
Lawn Larder | 3/7/23 | 11:30:00 | Sandwich - Egg |
| Lawn Larder | 3/7/23 | 11:30:00 | Crisps - S&V |
| Lawn Larder | 3/7/23 | 11:30:00 | Still Water |
| Lawn Larder | 3/7/23 | 11:30:00 | Express Bag |
| The Hill Larder | 3/7/23 | 11:35:00 | Salad - Feta |
| The Hill Larder | 3/7/23 | 11:35:00 | Popcorn - Butter |
| The Hill Larder | 3/7/23 | 11:35:00 | Fruit Twist |
| The Hill Larder | 3/7/23 | 11:35:00 | Still Water |
| The Hill Larder | 3/7/23 | 11:35:00 | Express Bag |
Im not sure how this can be sorted, maybe a range of 'choices'? So each possible combination has a 'choice' number or name associated with it? I cant work out how to do this though.
Any ideas please?
Thanks
