Challenge #292: It's about Pivoting, Prepping and Reporting!

[Michael_McKee]

Spoiler

 

[BMorgan1390]

GOOOOAAAAAALLLLLLL!!!!

[swelday007]

My first Weekly Challenge complete!

Spoiler

[Jana_Nandakumar]

Late post, but learnt Pivot and table..

[jaheath]

Thanks for the helpful video, well done! I was stuck before I watched your video. I did notice that the grand totals were doubled in each case, though. I moved the summary tool to earlier in the work flow and it looks like that worked so it didn't double count.

[PhilBalderson]

First weekly challenge completed on my M1 Mac. The Mac was faster than I was. 

Spoiler

[gun_ho_park]

Spoiler

[anabelvelazque]

Here is my take 🙂

Credits to Philip Mannering (I liked the way the challenge was solved!)

[kelly_gilbert]

This was a great challenge - thank you, @binuacs! I don't think I've ever had a requirement to include subtotals in a table, so it was a good puzzle to solve.

Output:

Workflow:

Spoiler

[dsmdavid]

Spoiler

I never quite remember how to use the cross tab to spit totals too, so...