Grouping by parent code and counting the parent groups ......

[RRSmith]

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

[ImadZidan]

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

[RRSmith]

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. 

[ImadZidan · Accepted solution]

Hello @RRSmith ,

This is something that may give you an idea. 

Hope it helps.

[RRSmith]

Can not thank you enough...….

Bravo!