How can the following "view"/new report be generated?
I have two forms, with the following data:
Form/Report 1 (Imported from external source 1)
A
B
C
D
E
Form/Report 2 (Imported from external source 2)
C
D
D
F
I want to make a new Report 3 which containes data which is in both Report 1 and 2, so in this case it should be:
C
D
I want to make a new Report 4 which containes data which is only in Report 1, which in this case should be:
A
B
E
I want to make a new Report 5 which containes data which is in only Report 1 or only in Report 2, so in this case it should be:
A
B
F
How can this be done in Creator?
Happy for all suggestions, leads and EXAMPLES :-)