User Profile
dhofland
Copper Contributor
Joined 12 months ago
User Widgets
Recent Discussions
Pivot Table from Related Tables
Hi all, I'm trying to display a bunch of data in a pivot table, but I'm having trouble getting it to show up like I want it to. My data is divided into multiple tables, but I believe setting up relationships between the tables could make it work. I have an example of the data (not my real data - just completely made-up information!) attached as a photo. Basically, all the data is related to a "name", and some of the data has only one entry per "name" (General Info table). Some of the data can have multiple entries per "name" (Repeated Info table), so I put that in a separate table so I don't have to duplicate all the other columns in the General Info table with each Repeated Info entry. I created a table relationship between the "Name" column of each table and tried to make a Pivot Table with the related tables. You can see that I put all the table columns as rows in the Pivot Table, arranged in tabular form. I anticipated that the Pivot Table would only show the "Jobs" linked to each "Name", but instead it shows all the "Jobs" for every "Name". I manually made what I wanted it to look like in the "What I Want" table. Does anybody know if it's possible to make the Pivot Table do what I want it to do? Should I arrange the data differently? Is it a Pivot Table setting? I would prefer that the "Repeated Info" table stay separate from the "General Info" table so that it's easy to add a line to the "Repeated Info" table if someone takes a new "Job". Also, why doesn't the Pivot Table stay in Data Source Order when I select that option? Thanks in advance, Daniel
