Reference One Column selection to another column, from list box

[dondapati]

Hello all,

In Text box , if user selected value from the list box, it reference to another column , corresponding matching rows.

Here my data looks like 

Company	Combined_Type	Place	Prod	Type
NA	HVAN/MVAN, PUP-D - Heavy	Oh	15992	PUP-D - Heavy
NA	HVAN/MVAN, PUP-D - Heavy	Oh	16239	PUP-D - Heavy
NA	HVAN/MVAN, PUP-D - Heavy	Oh	52146	HVAN/MVAN
NA	PUP-D - Heavy, E	Ken	257	E
NA	PUP-D - Heavy, E	Ken	957	E
NA	PUP-D - Heavy, E	Ken	352	PUP-D - Heavy
NB	PUP-D - Heavy	Fly	1517	PUP-D - Heavy
NB	PUP-D - Heavy	Fly	2014	PUP-D - Heavy
NB	PUP-D - Heavy	Fly	79037	PUP-D - Heavy
NB	PUP-D - Heavy	Fly	92192	PUP-D - Heavy

Expect Combined_Type, Prod everything is available in list box.

if user select the Value Type = "E" and Plan = "Ken" then Combined_Type list contains value's sum prod(257, 957, 352) value come.

because, here Combined_Type  column contains the "E"

I tried the trigger  on Type column

WildMatch(Combined_Type, '*'& getfieldselections([Type],'*|*')) 

But it not working,

Update:

I Tried Following 

sum( DISTINCT {<[Type] = { "$(=GetFieldSelections([Type]))"}>} Production )

how to check 

sum( DISTINCT {<[Combined_Type] = { "$(=GetFieldSelections([Type]))"}>} Production ) (Matching which are in Combined_Type)

Help me, how to reference one column to another column 

[Chanty4u]

can you try this?

=Sum({<Type = p(Type)>} Prod)

[dondapati]

Hi Chanty4u, Thank you for given reply.

Maybe i am not explain clearly, sorry for that.

In the same thing , if i include the list box for Type column and select value is E , then also the value is 1566 ,

because the selected value "E" is in 3 rows , with Combined_Type Column.
In the front end i can't place the Combined_Type Colum as List box.