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

Anonymous,

 

I already do like your suggestion but I cannot connect relation to both PBT and REVENUE due to the PBT and REVENUE already connect to COMPANY table.

 

Thanks

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    How do yo do that because I cant.

    See below figure.

     

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      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