How to connect data with Relationship

Hi All,

I have question, can we connect the data betweet two column without using relationship.

I have table REVENUE and PBT but I cannot create the relation betwwen this two table because of the duplication data.

But its connect to Company name on Company Table.

I want to combined this two table data in one dashboard and using Date filter by revenue data.

Now when i select the data filter, the PBT data connot filter by that because data filter is from Revenue Data.

How can I connect the REVENUE and PBT because the date data is same but its duplicate.

Thanks

Anonymous
8 years ago
Not sure how was your data structure. Did you try to create the following relationship? Linked the date from PBT/Revenue to Calendar table. The calendar table contains unique date information so it can be used as a bridge to create relationship between PBT and Revenue.
Anonymous
8 years ago
Anonymous,

Change cross filter direction of your relationships from Both to Single, then check if you get expected result as Jessica_Seiya descibed.

Regards,
Lydia

Forum Discussion