Challenge #63: Data Preperation Using Pivot Tools

[Nicholas_Bignell]

https://youtu.be/12JcDURDvhk

[dashakir1]

Thanks JoeM.

[MadsAdrian]

Spoiler

[JennyMartin]

Spoiler

Probably a bit convoluted but it works!

[serhiipavlenko]

Spoiler

  

[rmforcreamlisa]

I had a little help with this one as it was Intermediate level.  

[MohnishJain]

Thanks for the Challenge.

Am looking at the final solution provided by you, and in the final output of the solution I am seeing multiple rows where Total - Point of Sale is Zero even when Inside - Point of Sale is != 0.

Ex - for Week of 2016-04-24, Inside - POS is 236 whereas Total - POS is Zero.

Shouldn't, Total (POS) = Inside (POS) + Outside (POS)?

Thanks,

Mohnish

[tiffanyshaw]

Spoiler