Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 th...
Need Help
  • Anonymous's avatar
    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's avatar
    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

Anonymous's avatar
Anonymous
Not applicable
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's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

How do yo do that because I cant.

See below figure.

 

 

Thanks