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.
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.