Challenge #8: Aggregate Consumer Purchases

[JonServiceNow]

Completed Challenge. Solutions can be very different.

[cherrington]

My result

[basisally]

Note to new challengers: The Start File Objective asks for "since June" but the solution is calculated based on "since July"

[dmceleney]

solved

[Himanshu7781]

Thank you for an easy solution. I just started learning and your solution was the easiest. 

[JasonTylerYoung]

Spoiler

I got very turned around that "since June" meant from July 1, I had to check the boards here to figure out my error.  Also, it is a little confusing that the instructions say burger OR pizza, this felt like an invitation to exclude orders that had both a burger and pizza (i.e., because perhaps the meal deal would only apply to an order with one entre, a side and a drink?) however the final solution is based on numbers which do not exclude orders with burger AND pizza.  So, got me thinking critically and running scenarios which I guess is never a poor use of time.  Finally, I cannot seem to save my workflow with the original data input files preserved, I have saved my workflow without the input file to show my thinking, I hope my workflow can be helpful.

[Ajjay]

Soln

[Pmago89]

Here is my solution! 

[amanda_payne]

Spoiler