How to Create relationship?

[adityavighne]

Hi,

I have data like below in 3 different sheets.

Twitter 

Date	Twitter Page	Like
1/1/2017	Asia	1
2/1/2017	India	2
3/1/2017	China	3

Facebook

Date	Facebook Page	Like
1/1/2017	Asia	1
2/1/2017	India	2
3/1/2017	China	3

Combine sheet

Date	Total Like
1/1/2017	2
2/1/2017	4
3/1/2017	6

I want to create a relationship between Twitter -> to -> Combine sheet and same with Facebook -> to -> Combine sheet 

Can I create somehow? Is there any way to do this.

Kindly Help on this.

Regards,

Aditya 

[TeigeGao]

HI @adityavighne ,

In your scenario, you can create relationship between the Date column in Twitter table and Date column in Combine sheet, between Date column in Facebook table and Date column in Combine sheet, use the many-to-one relationship.

Best Regards,

Teige

[adityavighne]

This will not help.

I have already had a relation  between dates.

so when I select Date it gives me total likes not to drill down 

Can someone help with this?