Challenge #363: Coffee or Tea? That’s the question.

[dwstada]

my solution

Spoiler

[elena_mazareanu]

Solved

[katejoyce87]

Spoiler

[westlakecjw]

Spoiler

[hharris0411]

Spoiler

[tsand22]

KAR Solution

[PratikPP]

Here is my Solution...!!

[joeoswald614]

Fun Challenge!

Spoiler

Tools used:

1. Select tool to change sales to Int16
2. Cascading Filters - 2 Sets, 1st set below
   1. Regular Coffee
   2. Decaf Coffee
   3. Regular (is Tea by default) (False output = Decaf)
3. Cascading Filters - 2nd Set
   1. Coffee (False output = Tea)
4. On each of the 6 output anchors, run the following tools:
   1. Summarize
      1. Group by State, Sum Sales for 1st 4
      2. Group by product_type, Sum Sales for last 2
   2. Sort all Sum_Sales Descending
   3. Sample 1st Row
   4. Filter to add name row
   5. Select to update naming
5. Union tool to combine the 6 outputs in the correct order.

[CasperBuenting]

Spoiler

Not the most efficient one, but it worked

[MattBenj]

My solution