Forum Discussion
Excel Power Pivot. Related tables, pivot table repeats all row records
I have two tables that are connected by "Name." "People List" is a unique list of people, then "Responsibility" is accounts that they have ownership of:
Both tables are connected by "Name"
I need to organize it within a pivot table so that the "Name" comes from People table, and "Customer" from the Ownership list.
The problem that I'm experiencing is that when I drop these into the "rows" on my pivot table, account names repeat for each person.
How do I fix this so that only the assigned customers are visible for their respective people?
- There's probably an elegant way to fix but my first thought is to add an isblank() check in an if statement.
9 Replies
itchyeyeballsImpactful Individual
What have you got in the values section of the pivot?- itchyeyeballsIf you drop in name from your ownership table the extra rows should go away