troubleshooting Question

powerpivot relationships not detected

Avatar of agwalsh
agwalsh asked on
Microsoft ExcelMicrosoft SQL Server
4 Comments1 Solution733 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros