Making a New Cummulative Field from existing 2 fields

[Anonymous]

Hi All,

I have 2 fields Dealer Code, Parent Dealer Code . Both fields have value against them.  I need to club the data for Parent Dealer  Code + Dealer code to get cummulative sum of value of both .

Parent Dealer Code	Dealer Code
P1	A1
P1	A2
P2	B1
P2	B2
P2	B3

Parent Code	Value
P1	56
P1	56
P2	70
P2	70
P2	70

Dealer Code	Value
A1	50
A2	10
B1	29
B2	40
B3	60

I thought to create a new dealer field to get cummulative sum of value of both fields regardless of any field(Parent Dealer Code Or Dealer code) value selection   I want to create a "NewField" to get cummulative sum on front end . Please help.

NewField	Dealer Code	Value
P1	P1	116
P1	A1	116
P1	A2	116
A1	P1	116
A1	A1	116
A1	A2	116
A2	P1	116
A2	A1	116
A2	A2	116

[effinty2112]

Hi Apoorva,

This is your data in one table:

Parent Dealer Code	Dealer Code	ParentValue	DealerValue
P1	A1	56	50
P1	A2	56	10
P2	B1	70	29
P2	B2	70	40
P2	B3	70	60

What is the logic to get from the above to:

NewField	Dealer Code	Value
P1	P1	116
P1	A1	116
P1	A2	116
A1	P1	116
A1	A1	116
A1	A2	116
A2	P1	116
A2	A1	116
A2	A2	116

?

Regards

Andrew

[Anonymous]

Hi,  I want to show Value : 16462715 and Qty 2975 against any parent dealer code or any Dealer code .  Both should have same value which is = Parent value+ child Value

ParentDealerCode	DealerCode	ParentChildStatus	Value	Qty
			16462715	2975
ANDD0711	ANDD0711	Parent	11353561	2276
ANDD0711	TELD001155	Child	5109154	699

[Anonymous]

I want to Clubb data  for all parent and child codes .