Challenge #1: Join to Range

[krishnakumare]

I  have attached the solution which I devised. This may not be the best way. But, posting it.

[VipulThakur]

Solved this challenge with 3 Tool 

1. Formula 

2. Join 

3. Summary 

1. Formula: I use this to Categories Region ( R1, R2, R3) using If elseif formula.

2. Join: Joined both using region.

3. Summarize: Region, Sales Rep and Responder by Group, and Region by Count

[nicks2587]

Completed

[Rain7]

Completed.

Spoiler

[LynnPätzold]

Felt like I had to do the infamous first challenge ;)

Spoiler

 

Spoiler

 

[zorecchi]

Left to my own devices, I would've probably used the formula tool to assign the regions by brute force. Haven't learned too much about the generate rows tool, so I followed the general solution for my own education. With only a few regions, this could be done by brute force. But, as the number of regions increases, doing it this way wouldn't be very efficient. Solution attached. Not so much different that the general solution, but uses one less select tool since the second one is unnecessary (the join tool can also serve as the second select tool).

[hholloway1]

Here's my solution!

[lucaskro]

Spoiler

[tristank]

Spoiler

Challenge 1 Completed. Good to practice the generate rows tool! 

[tristank]

Interesting approach