Hello Everyone,
This is the input and the desired output. Can someone please help me with creating a workflow for this.
Regards,
Ragini
Input-->
Level 1 | Level 2 | Assignment |
10000 | 100001 | 3100004 |
10000 | 100001 | 3100005 |
10000 | 100001 | 3100006 |
10000 | 100001 | 3100007 |
10000 | 100002 | 3100008 |
10000 | 100002 | 3100009 |
10000 | 100002 | 3100010 |
10000 | 100002 | 3100011 |
20000 | 200001 | 3100012 |
20000 | 200001 | 3100013 |
20000 | 200001 | 3100014 |
Output->
High Level Group | Low Level Group | Profit Center |
10000 | ||
10000 | 100001 | |
100001 | 3100004 | |
100001 | 3100005 | |
100001 | 3100006 | |
100001 | 3100007 | |
10000 | 100002 | |
100002 | 3100008 | |
100002 | 3100009 | |
100002 | 3100010 | |
100002 | 3100011 | |
| 20000 | |
20000 | 200001 | |
200001 | 3100012 | |
200001 | 3100013 | |
200001 | 3100014 |
Solved! Go to Solution.
Hi @Ragini1,
Will this accomplish what you need? I got there doing various summaries and writing conditional statements in the Formula tool...then just cleaned up the column names at the end.
Hi @Ragini1
I could be getting myself confused, but I thought I had responded to this post, or did you ask the same question twice in a different post? haha. If not someone had the same use case as yours haha.
Here is the solution I came up with:
Pedro.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |