Challenge #8: Aggregate Consumer Purchases

[Awesomeville]

My Solution for Challenge #8.

[adityan92]

Bring it on! 

[Loic]

my solution. I think it is simpler than some others. I filter first then create 3 flags and aggregate without using any transpose, cross-tab or complicated joins.

[kxs]

Second challenge completed!  Took me a while though...  Hopefully with practice I start getting the hang of it. 

[mgcarrenard]

My solution.

[pfredin]

Here is my solution.

[jagdeep_singh85]

please find my solution in attachment

[erick_irigoyen]

Attached is my response. My goal was to consolidate all orders by member ID in just one row. To do so, I used the "Summarize" tool and then used the formula tool to calculate the final metrics. 

Thanks

[TimothyManning]

Spoiler

I like the Data Analysis challenges