Forum Discussion
problem with relation between table (newbie)
i have relation like these. In table projectdata I canuse related to salesName but I cannot use related to projectsubdata (I try to typing but it show nothing )
And second problem
if I related to userdata- sales it can related but show nothing.
thank
2 Replies
- amitchandak
Super User
Anonymous , Based on what I got. Related can only be used from 1 side to many side. You can create new column on Many side .
You can try relatedtable for 1 side
example
sumx(relatedtable(projectData]),[Est Fee])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8 - ALLUREAN
Solution Sage
Hi, Anonymous
You need to follow the star schema or snowflake schema in your data model. In your case you probably have more than 1 fact tables. In order to get correct results it is good to follow it. You can use LOOKUPVALUE instead of RELATED but this will not be a solution and maybe will cause some issues with data.
