Guidance need to best way to desgin my data model

[srinivasa1]

Hi All,

I have wired requirements to incorporate in   my my data model  and i have below requirements to achieve

Main Seller TransID	Order#	Sub Seller TransID
XX1	ABC01	XX1
XX1	ABC02	XX1
XX1	ABC03	XX2
XX1	ABC04	XX2
XX1	ABC05	XX2
XX2	ABC06	XX1
XX2	ABC07	XX3
XX2	ABC08	XX3

If I select  Main Seller TransID=XX1 Then I wanted to do

count of Order# belongs to Main Seller TransID(#XX1) + Sub Seller TransID(#XX1)(5+3=8) and Same way in case  I select Main Seller TransID XX2(ie 3+3=6)

See here   Main Seller TransID has 5 Order and it and  also   Main Seller TransID(XX1) found    Sub Seller TransID that’s (XX1 )  and it has 3 Order in that case wanted desgin my data model such way when I select Main Seller TransID(XX1)  I need add order of  Main Seller TransID(XX1)5  +3 Sub Seller TransID that’s (XX1 )

Attached Sample app and details for same.

Thanks in advance  for any help on achieve this best way

[settu_periasamy]

Create on Variable like

v1 :  =Concat(DISTINCT chr(39)&[Main Seller TransID]&chr(39),',')

In the text box try the below expression

=Count(Order#) + Count({1<[Sub Seller TransID]={$(v1)}>}Order#)

[srinivasa1]

Thanks Settu,

Do you have any idea how I can achieve this in ETL script?

Thx