Challenge #8: Aggregate Consumer Purchases

[Ereon]

I am unsure where I am going wrong.  I have gone back and checked everything to verify that i am assigning the correct values, etc, but keep coming up with less "Potential Meal Deals" than the solution.  Any help would be appreciated.

[eraaz_lala]

Hello

Please find my solution to challenge # 8

Regards

Eraaz

[Minsu]

Here is my solution!

[mkreddy]

I 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

[RAJPUTSAURABH]

Please find the solution

[KORKIS3]

Spoiler

Simple Solution  : )

[RAJPUTSAURABH]

Please find attached solution

[lhalliwell]

Spoiler

 

[RAJPUTSAURABH]

Please find attached

[hdavison]