powerpivot relationships not detected
hi Folks
I've got a master chart of accounts list - unique identifier called LinkID. I have 3 sets of trial balances each of which has a unique field called LinkID as well. Each of these linkIDs has a balance attached to it. e.g. Retail sales PTD and Retail Sales YTD.
So I have a one to one relationship, as opposed to a many to one relationship. I have tried creating these relationships both ways and in both cases when I go to add the values i.e. the YTD and PTD values to the powerpivot I am told "no relationship is detected". The Related function does not work to allow me to pull in matching values - so that even though it looks as though the relationships are working...they are not. Any suggestions?
I've got a master chart of accounts list - unique identifier called LinkID. I have 3 sets of trial balances each of which has a unique field called LinkID as well. Each of these linkIDs has a balance attached to it. e.g. Retail sales PTD and Retail Sales YTD.
So I have a one to one relationship, as opposed to a many to one relationship. I have tried creating these relationships both ways and in both cases when I go to add the values i.e. the YTD and PTD values to the powerpivot I am told "no relationship is detected". The Related function does not work to allow me to pull in matching values - so that even though it looks as though the relationships are working...they are not. Any suggestions?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
>> even though it looks as though the relationships are working...they are not
Could you please elaborate on how they look like there are relationships. Some screenshots would help.
Have you gone through the procedure here: https://support.office.com/en-gb/article/Create-relationships-in-Diagram-View-in-Power-Pivot-12e00cb6-cb4d-469c-97ce-caa08349ad76?ui=en-US&rs=en-GB&ad=GB
Do you have more than one relationship per set of tables? (as PowerPivot will only use one). If so, use USERELATIONSHIP.
Could you please elaborate on how they look like there are relationships. Some screenshots would help.
Have you gone through the procedure here: https://support.office.com/en-gb/article/Create-relationships-in-Diagram-View-in-Power-Pivot-12e00cb6-cb4d-469c-97ce-caa08349ad76?ui=en-US&rs=en-GB&ad=GB
Do you have more than one relationship per set of tables? (as PowerPivot will only use one). If so, use USERELATIONSHIP.
I can see them in the Relationship window (Diagram View) going from Company 1 to Chart of accounts, going from Company 2 to Chart of accounts, ditto for company 3. All linked on LinkID field. No, just one relationship per table...so I create them, they appear in the Diagram window. I now have one of the company files relationships working...so still have two to go..
Premium Content
You need an Expert Office subscription to comment.Start Free Trial