total transaction calculation amount using enrichment in Adobe campaign classic

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

we are  stuck in one situation

please help

we need to find out total transactions made my customers

we have customer details stored in customer schemas

and transaction details like transaction Amount,transaction id is stored in Transaction schema

so i have tried to create this as below

1.Query activity to fetch the recipient details like first name, last name etc

2.enrichment Activity to create a link with Transaction schema

3.another enrichment activity i have used aggregate function : sum(Transaction amount)

But now here in output m not able to get total sum of transaction made by customer,m getting count in output transaction as 0.

so basically I am stuck here

please help me here

what i need to add in

Thanks in advance