Challenge #434: Summing Across Many Rows

[braveraj]

Spoiler

[ed_hayter]

Good reminder pivots and unpivots remain a 'pivotal' skill

Spoiler

[ferg_smith]

Lovely little pivoting challenge

[ggruccio]

I had to round the solution to 2 decimal places as well to get the match!

Spoiler

[JamesCharnley]

Spoiler

Nice lines

[HFulghumES]

Spoiler

I'm a bit perplexed that the "answer" output still had a null value, but everything else lines up. 

[sfarnham1]

Proposed solution

[ScottLewis]

Getting better at the flipping, unless you count not remembering which one is cross tab and which one is transpose.

This one was interesting because the obvious design changes if you think about doing both things rather than doing 1 then 2.

There's also a nice hidden lesson in extensibility. What if there was a new code? A new GEO_ID? Both? Would your process still work? 

 

[erike601]

Spoiler

[SPetrie]

Spoiler