Hello,
I am developing a database in PowerPivot and I am wondering how to create many relationships between the same 2 tables. All relationships must be active.
Let me give you a DUMMY example: let's say that the database has 2 tables, the Employee table and Manager table (below images).
Because I have 2 manager fields in the employee table, I need to create 2 links between the employee and manager tables (see below images).
Right now, one of the links is inactive...
Is there a way in PowerPivot to create 2 active links like that ?
Thanks for anyone who can help !
P.S.: I have Power Pivot version 11.0.3000.0 on Excel 2010 on Windows 7
I am developing a database in PowerPivot and I am wondering how to create many relationships between the same 2 tables. All relationships must be active.
Let me give you a DUMMY example: let's say that the database has 2 tables, the Employee table and Manager table (below images).
Because I have 2 manager fields in the employee table, I need to create 2 links between the employee and manager tables (see below images).
Right now, one of the links is inactive...
Is there a way in PowerPivot to create 2 active links like that ?
Thanks for anyone who can help !
P.S.: I have Power Pivot version 11.0.3000.0 on Excel 2010 on Windows 7