Make a Calculated Field in Joined Table

[rmdnkevin]

Hi, everyone.

I have this table view :

The contents from status field on 20180612 table are Email Sent, Email Opened, Clicked Link, Submitted Data.

I need to make a join table with fields are : Date, CountofEmailSent, CountofEmailOpened, CountofClickedLink, and CountofSubmittedData

with the example of expression from CountofClickedLink = sum of Clicked Link + sum of Submitted Data from status field on original table.

How can I do that ?

Thank you

-Kevin

[sushil353]

Hi Kevin,

Your issue is not clear by the statement : with the example of expression from CountofClickedLink = sum of Clicked Link + sum of Submitted Data from status field on original table.

It is better if you can attach a sample qvw.

HTH

sushil

[rmdnkevin]

Here I attach the simulation of the datas.

-Kevin

[Anonymous]

Hi Kevin ,

Can you provide your expected  result?

Best Regards,

Ashok

[rmdnkevin]

Here's the table what I expected :