I am trying to Group by parent code and count the parent groups and applying a parent id to each child record
Current record set
Parent code | Child record ID | Child code | Qty per |
abc | 1 | 3658 | 2 |
abc | 2 | 8452 | 1 |
def | 1 | 7458 | 2 |
def | 2 | 9658 | 5 |
def | 3 | 2358 | 1 |
ghi | 1 | 4521 | 2 |
ghi | 2 | 1528 | 8 |
ghi | 3 | 3325 | 1 |
ghi | 4 | 4256 | 1 |
I have sorted by Parent code. Now I would like to count the parent groups and apply the parent ID to each child record:
Parent ID | Parent Code | Child record ID | Child code | Qty per |
1 | abc | 1 | 3658 | 2 |
1 | abc | 2 | 8452 | 1 |
2 | def | 1 | 7458 | 2 |
2 | def | 2 | 9658 | 5 |
2 | def | 3 | 2358 | 1 |
3 | ghi | 1 | 4521 | 2 |
3 | ghi | 2 | 1528 | 8 |
3 | ghi | 3 | 3325 | 1 |
3 | ghi | 4 | 4256 | 1 |
I have tried with the summary tool and the multi-row formula tool and can not get the desired result. I feel the Multi-row formula would do it; I nee a little help getting it right.
RRSmith
Solved! Go to Solution.
Hello @RRSmith ,
I have looked at the scenario.
Not sure its clear to me. So your expected out put is ?
This? How are you counting the groups. Sorry for the questions. Just trying to understand.
Parent ID | Parent Code | Child record ID | Child code | Qty per |
1 | abc | 1 | 3658 | 2 |
1 | abc | 2 | 8452 | 1 |
2 | def | 1 | 7458 | 2 |
2 | def | 2 | 9658 | 5 |
2 | def | 3 | 2358 | 1 |
3 | ghi | 1 | 4521 | 2 |
3 | ghi | 2 | 1528 | 8 |
3 | ghi | 3 | 3325 | 1 |
3 | ghi | 4 | 4256 | 1 |
the table above is the existing record set. The bottom table is what I am attempting to accomplish. would like a count of unique parent groups and the group ID (count value) appended in new column. Ultimately, each record should have a field identifying the parent group it belongs to 1, 2, 3, etc.
Thanks for the rapid reply, if more explanation is needed, don't hesitate.
Can not thank you enough...….
Bravo!