Relation between tables

[Anonymous]

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 Many" and "Many to One".

I've created two tables with these datasets:

1. Stage of the Opportunity and #Opportunities from Opportunity Table
2. Details of the Opportunity i.e. Account Name, User Name, Opportunity details from all the three tables.

When I pull the data into  "Table 1", I can see the data being listed, however, When I try to select a stage of the opportunity from the data with "#Opportunities" in Table 2 I'm not able to see the data being filtered.

Any help on this would be appreciated.

[v-eachen-msft]

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]

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

[Greg_Deckler]

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?

[Greg_Deckler]

Can you post an image of your model? Need to see directions of relationships, etc.

[Anonymous]

@Greg_Deckler This is the model of my dataset.