Forum Discussion
How to connect data with Relationship
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
Do you want to filter data based on date? If this is the case, try to create a specific calendar table and then link it with the REVENUE and PBT tables. Then use the date info from calendar table for flitering.
Hope it helps
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
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.
Hi Anonymous,
How do yo do that because I cant.
See below figure.
Thanks
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