Challenge #457: Profit and Loss Statement

[cpoveromo13]

I'm confused - why is the data not grouped by month? I don't think it's accurate to combine January 2019 data and January 2024 data. Am I missing something?

[tammybrown_tds]

Spoiler

[jpowellsd]

Great challenge!  It took a minute to figure out why my totals weren't matching the output.

Spoiler

Finally realized that sorting before adding cross tab did not ensure that month column headers would be sorted correctly, had to add the month num, then remove it after doing cross tab. 

[quianalee88]

This challenge had me working into the night! I just could not get past summarizing the months. When I finally broke down and reviewed the solution, I saw the DateParse tool change the date into two digits. I wanted to hit myself. With every challenge, even the ones that stump me, I'm learning new ways to solve analytical problems. So, it's a win all the way around!

[Fangfang]

First time join the challenge.  Not sure how to insert spoiler. And... why someone's flow is so complicated while mine are so simple? Am I missing some important rule?

[Dhrish]

Spoiler

[AkimasaKajitani]

My solution!

Spoiler

[RolandSchubert]

Spoiler

[Sebastian_Chaieb2]

Nice and easy one

Spoiler

 

[jfissel]

Spoiler