Challenge #102: Tabulating Flu Data

[SB09]

Thanks for the solution.

How did you calculate the values? The data type should be numeric to get the summation of Weekly Rates, but the Weekly Rate has data type V_String.

[loganmjung]

Took some inspiration from other spoilers and was able to come up with a solution. 

[Milanz]

Done 😉

Spoiler

[loganmjung]

I'm not privy to formatting on the community but how do you create the spoiler drop down?

[LukaszKarpinski]

I attached my solution below:

[KGS]

Hi,

Attached my solution.

Best,

G

[DMContente]

My solution

[parkerjackson42]

Really enjoyed this one!  Does anyone have suggestions on maintaining the integrity of the column names and not allowing the Cross Tab function to separate values by an underscore?  Love to hear your thoughts!

Spoiler

---

[Tberney]

Not too hard. Anyone got a read on what the "Overall" column is supposed to capture, or any thoughts on why the exercise excludes it?

[LaurenU]

Spoiler