Forum Discussion
Solved
Hierarchies across multiple linked tables
Hi all, I am in need to create a hierarchy that goes across tables, these tables are linked through 1 to many relationships. The structure I need to have is something like this: -Company ...
Hi,
In that case I would suggest for you to do an IF STATEMENT inside which you should place this Lookupvalue. Basically,it can be like
IF (Parentid《》blank(),lookupvalue function, else block)
Hi,
You could use a LookupValue Function in Table 2 to bring in Company column in the Second Table.
Otherwise, If you are using SSAS, then you can also Create a Hierarchy over there and Import/ Live Data.
Anonymous I have used the formula like this:
Parent Account Name = LOOKUPVALUE(salesforce_account[name];salesforce_account[id];salesforce_account[parentid]; )
But I want to expand it to look at the account name if the parent ID is blank. How can it be done?
Hi,
In that case I would suggest for you to do an IF STATEMENT inside which you should place this Lookupvalue. Basically,it can be like
IF (Parentid《》blank(),lookupvalue function, else block)