Forum Discussion
Many to Many Relatioship
Hello All I'm Trying to create a report where i have two Table as Error Table and Client Record. Both table have Many to Many Relation and Both as cross Filter Drection . I have tried c...
Hello Kelly
I have created bridge table but it didn't work as expected
I have created bridge table but it didn't work as expected
Hi Anonymous ，
I made 2 sample tables which have many to many relationship,see below:
Would you pls advise me what is your expected output?
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!
Hi v-kelly-msft
Thanks for helping, i will give you below data sample please refer,
error table sample
DUPLICATE FIELD CUSTODIAN CLIENT CREATE DATE Duplicates GBS CDM Atlanta North America 4/1/2020 Street GBS CDM Atlanta North America 3/1/2020 Street GBS CDM Atlanta North America 3/1/2020 Name1 GBS CDM Atlanta North America 3/1/2020 Name1 GBS CDM Atlanta North America 3/1/2020 Client Record Table
Group Type Group Name Record Count CREATE DATE Client Corporate 3 4/1/2019 Client CPS EEA 3 4/1/2019 Client CPS Asia 2 4/1/2019 Client CPS EEA 1 3/1/2020 Client CPS Latin America 4 4/1/2019 Client CPS Latin America 2 4/1/2019 Client CPS Latin America 2 4/1/2019 Client Corporate 1 9/1/2019 Client Corporate 1 9/1/2019 Client Corporate 1 1/1/2020 Client Corporate 1 3/1/2020 Client Corporate 1 3/1/2020 Client CPS Asia 2 4/1/2019 Client CPS Asia 1 4/1/2019