Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAAs with many of the challenges, I don't always agree that less tools are better. I definitely could have combined some of the summarise tools, and in some cases, the Cross-tab will do it for you. I cheated with the sort order to prevent having to order in the Union and I corrected the headers as that's a trick that everyone needs to know.
LESSION LEARNED:
I was stuck on how to get Grant Total from 1st Row to Last Row. Today came to know that sometimes to achieve Sorting you just need to manipulate by adding new column with 0's & 1's. Thanks for the trick @Aaron_Harter.
(Hope someday @AYXAcademy flags my reply as Solution. Eagerly waiting for that day)
I am using more tools than other persons.🤔
My solution: