Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I would usually transpose and filter in this case, but I thought I would skip that and find 2 other ways
Spoiler
The first uses Dynamic Select to split the data, and after doing the calculation, I couldn't decide which way to combine the data back, so included both.
The second method uses the arrange tool, I normally don't like having that much manual configuration, but given they are months, I don't think extra data would need to be dealt with.
The second method uses the arrange tool, I normally don't like having that much manual configuration, but given they are months, I don't think extra data would need to be dealt with.
My solutions:
Spoiler
Difficult to find a second way to do it, utilized the Arrange tool to Transpose but it led to it becoming more manual as well.
Looking at other solutions, there are so many different ways I could have solved this. Love these type of challenges.
