Forum Discussion
Relationships between three tables
Scenario --> my customer is selling his products through three online services(A, B, C) He wants to compare the sales, quantity,.. between them. The issue here is there are no common fields among ...
On which level your customer wants to compare the data? Only grand total sales and grand total quantity?
Pretty easy: you don't need a relationship. Just create those two measures for each service and put them into a visual. And you are done.
But actually I can't imagine that the source data just looks like this:
Product_ID | Sales | Quantity
😉
If your customer wants to compare per product, asked them to provide a relationship table between the products of the different services.