Forum Discussion
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...
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,
Change cross filter direction of your relationships from Both to Single, then check if you get expected result as Jessica_Seiya descibed.
Regards,
Lydia
Hi Anonymous,
How do yo do that because I cant.
See below figure.
Thanks
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