Forum Discussion
Solved
Pivot Challenge
I'm hoping someone can steer me in the right direction. I have a table with a list of employees and and calculated benefits for their weekly check. I need to be able to upload this data but I'm not...
Hi AskGenie ,
My apology for not paying enough attention.
Starting point: (Based on the file I attached earlier) Step: Changed Type
We need two steps to achieve the outcome:
Step1: GroupBy
Once the GroupBy step generated, go to the formula bar replace the highlighted code below (Image A) with highlighted in Image B.
Image A
Image B
The next step is add a custom column with code below:
The final step is to combine all the tables by adding a custom step (blue circle below) and add the highlighted code:
Regards
KT
BRILLIANT! Thank you soooo much. I don't exactly understand what we did here but it works perfectly. 🙂