Sales bij supplier not showing data

[lekkerbek]

Hi,

I have the following related tables. Some lines are in dutch, but I think you'll understand.

Each article has a main supplier ("artikelbestand - crediteurnaam"). I would like to show the sales of each supplier.

I related the "artikelbestand" with "salesinvoicelines", but when I try to create a matrix it doesn't show any sales by supplier.

Anybody an idea of what might be the problem?

[lekkerbek · Accepted solution]

Solved it. The many to didn't have effect.

I used the creditorname from the creditor table (wrong) in stead of the creditor name from the "artikelbestand" table (correct). 

[richbenmintz]

great, 

glad you solved it

[richbenmintz]

I think you would want a one to many relationship with a single direction rather than both directions as depicted. could you also provide your pbix as this makes it much easier to understand the issue and provide a solution

Thanks,