Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution attached.
This one is beyond my knowledge way too much , it took me hours even after I looked into others solutions to create my own.
Things I learned from this challenge:
1. fill in data into empty field with expression
2. how to use pivot to stack data sets with multiple columns.
Hi everyone,
below I send my solution to challenge # 63
In solving the problem I followed the following steps, according to the following rule:
IDENTIFY, BREAK DOWN, TRANSFORM AND REASSEMBLE.
Since in the use of the Transponse tool, the data is transformed into two columns, I asked myself how to create a third column to reorder the data through the Cross Tab tool. I thought of using the tool of the Mult-Row Formula, to create this field both to create a column of the DMA, both to create a column of the periods of "Weeks of" in the respective subset tables.
Below is the description of the steps that I weighed to follow:
I tested by copying and pasting 3 new fields according to the recurring pattern, and the workflow should work.
I would be happy with your feedback
Thank you all
good job
Hi everyone,
In solving the problem I followed the following steps, according to the following rule:
IDENTIFY, DISASSEMBLE, TRANSFORM AND REASSEMBLE.
Since in using the Transponse tool the data is transformed into two columns, I wondered how to create a third column to reorder the data using the Cross Tab tool. I thought about using the Multi-Line Formula toll, to create this field and to a column of the DMA, either to create a column of the periods of "Weeks of" in the respective subset tables.
Below is the description of the steps I weighed to follow:
I tested by copying and pasting 3 new fields according to the recurring pattern, and the workflow should work.
I would be happy with your feedback
Thank you all
Good job
This one was challenging. I noticed that the solution had a lot more complex coding in some of the tools. Also, when I got to the end, my answers didn't match. Discovered it was because I took the extra step to calculate Total POS.
my solution 🙂
This was a hard one. I went the macro route to process 3 rows at a time and union them. Seems like there has to be an easier way, but it got the job done ...