Forum Discussion

Kaskazi_Network's avatar
Kaskazi_Network
Icon for Helper I rankHelper I
5 years ago
Solved

Relationship between two Tables

Hi all, So I have two tables, 'Outlets Table' and 'Customer/Distributor Table' as shown in the dummy tables below. I need to create a relationship betwen the two tables so that I can show Comparison...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Kaskazi_Network ，

     

    Based on your description, you can do some steps as follows.

    1. Create a many-to-many relationship between two tables.

     

    1. Create a table visual. (Choose “count(distinct)”)

     

    Result:

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.