Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to recreate a Cognos report. The first page will show a full list of all customer records. When a customer record is drilled through, all records with matching CustomerName OR matching TaxID are displayed. The goal being to identify duplicate customer records.
I have searched for a solution to this question to no avail. I am looking for any way to move from a master list down to a list filtered by CustomerName OR TaxID
Hi @Anonymous ,
Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.
Regards,
Frank
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |