Challenge #63: Data Preperation Using Pivot Tools

[data_rachel]

Spoiler

[ianwi]

My solution below. I think/hope it's dynamic...

Spoiler

[Kenda]

Spoiler

Changed my output slightly from the given file so that the total would be the inside + the outside if it is missing. Also made it so that the headers would keep their original formatting instead of changing all of the special characters to underscores in the Cross Tab.

[jamesrichards]

After looking at the official solution, I feel good about mine. While working on it, it seemed so convoluted I thought there must be a better answer!

[ipeng]

It took longer than I expected

[RolandSchubert]

My solution

[KeithTroutt]

My solution.  I used a few more tools than the solution provided but I achieved the same results.

Spoiler

[RichoBsJ]

Hi! Here my solution :)

[Mikkel_D_Karlsen]

Thank you for a good challenge, it deserves a star :)

Here is my solution with the use of Basic tools

Spoiler

[yash123]

Would the difficulty in the designer core exam be the same as this challenge?