I have 3 tables, basic but somehow I can't add relationship.
In powerpivot diagram I can add but when analysing data on pivot table they don't work. Attached is the excel sheet. All tables are linked by ID.
Table 1 has ID Is all unique. all items in table 1 can be found int table 2. But table 2 and table 3 have more aditiional items that those on table 1
Report I am trying to create is a simple, but the pivot table is not working (i guess relationship although defined in powerpivot, are not working) because second lookup table items are repeated. In fact ID 1234511212341230 has only one email but it's repeated on the pivot table (imabe below)
What I need is that pivot table to be as follow
Row Items:
Table 1D Table 2 emal Table 3 Amount *Total count*
(report value can be count or anything, I will not use, I am interested in pivot rows only)
My goal is to replace vlookups because in reality those 3 tables are very large large and I don't want to manual vlookup all the time.
Untitled.jpg
2.png
Bookmarks