Challenge #190: Supply Chain Management Challenge

[SandeepSK]

Spoiler

My solution as pictured below and attached.

[bjkay30]

Here's my attempt at this.  After I did this, I realized that I could have concatenated the splits with a sum tool instead of the crosstab/transpose combo, and could have eliminated 4 or 5 extra tools.

Spoiler

[ConradW]

complete

[dombaikamilla]

Spoiler

[markcurry]

Spoiler

 

[Jean-Balteryx]

Here is my solution !

[ggruccio]

Had to manually insert the text "[Null]" to get an exact match.

[Verakso]

Okay, it has been a while, so this was a nice challenge to get back in the saddle 😉

Spoiler

So here it is, kind of messy, but in the end, I did get to match the result
My Messy WorkflowThere was one thing that seemed really odd to me, and that was the field [Total Prior APV] that in the provided result was not Null, but saved as a string with the value "[Null]". I simply do not know why you would do that, but in order to match the result 100% I added the weird function

Still climbing
/Verakso