Hey guys,
I'm pretty new to the data model and kinda curious about the relations possible within the data model.
For my current project, I need to be able to use data out of 40 (short) Tables with identical columns with a pivot table.
The Columns for each table are MONTH, STAGE, Number of CANDIDATES.
Despite not fully understanding the foundation of the data model relations, I figured out I need many to many relations. Therefore I added two unique tables for month and for stage (MONTHUNIQUE, STAGEUNIQUE) an connected the with my 40+ tables.
But when trying to set up a pivot table using these connections excel shows the same values for every column.DiagramView.JPG
PivotView.JPG
What am I doing wrong? Would be grateful for any advice!
Thanks in advance!
Bookmarks