Unable to create relationship between two columns

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!

jthomson
Solution Sage
8 years ago
I wouldn't have thought you'd have needed to make a relationship in order to create the visual you want?
v-huizhn-msft
Microsoft Employee
8 years ago
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
  Frequent Visitor
  8 years ago
  Thanks for the response, I have fixed the problem!
  - v-huizhn-msft
    Microsoft Employee
    8 years ago
    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

Forum Discussion