Redundant values

[Anonymous]

I have a first table

Sales

Idsales.    Amount.  Region

11.          100.          Paris

12.          200.          UK

A second table product

Idsales.    Product name.  Product color

11.           Pc.           Black

11.           Mobile phone.  Red

11.          Notebook.          Blue

12.         Pc.          Black

My problem with the granularity, when I need to display 

Idsales    product name.   Product color.    Amount

11.          Pc.      Black.     100

11.           Mobile phone.   Red 100 

11.           Notebook.   Blue 100 

 12.       Pc.       Black.    200

I have redundant values which is wrong, how to correct it? What is the best solution to get the good results? 

[v-jingzhang]

Hi @Anonymous 

Your sales table contains total sales rather than sales per product, so how do you want to break down the total sales on products for every sales id? Could you share specific expected result to show?

Best Regards,
Community Support Team _ Jing Zhang

[Anonymous]

@Anonymous what exactly you want to visualize, let me know, ideally the result above is what you would get if you create a relationship with Sales.ID = Product.ID.