Forum Discussion
Relation between tables
Hi, I'm working on a report with three different tables (Accounts, Users and Opportunities) pulled from SalesForce. I've created relationships between these tables with Cardinality as "Many to Ma...
v-eachen-msft The dataset I'm currently working on is confidential data.
Why does your Accounts to Opportunities relationship come out many-to-many? Are there really single opportunities tied to multiple accounts? Aren't accounts unique? Could you remove duplicates in your accounts list? Obviously I would expect an account to potentially have multiple opportunities. Could you mock up some data?