Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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 |
I want to Clubb data for all parent and child codes .