Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

Could you please share your sample data and excepted result to me if you don't have any confidential information. Please upload your files to One Drive and share the link here.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-eachen-msft The dataset I'm currently working on is confidential data.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      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?