Unable to create relationship between two columns

[tainguyen]

Hi Guys,

I am trying to create a visual displaying the amount of signed deals we have made in a Quarter.

Here is my Lead CSV file which shows the Month, Quarter, Company Name and Status

The problem is that i am unable to create a relationship between these two columns because one of the columns must have a unique value.

This is the part i am confused about.

Please help!

Thanks in advance!

[v-huizhn-msft]

Hi @tainguyen,

We can't create relationship when both of the two columns have no unique value. So please discribe your expected result and all your sample structure, we will check if you can get expected result without creating relationship.

Best Regards,
Angelia

[tainguyen · Accepted solution]

Thanks for the response, I have fixed the problem!

[v-huizhn-msft]

Hi @tainguyen,

Congratulations, you have resolved your issue by yourself, welcome to share your workaround or mark the helpful replay as answer, so more members in this community can get solution easily and clearly.

Best Regards,
Angelia

[jthomson]

I wouldn't have thought you'd have needed to make a relationship in order to create the visual you want?