Hello Everyone
I'm using Excel 2016
I have an issue creating a simple pivot table from 2 tables
I have two tables (Parents, Children) , with one to many relationship between the tables (One parent can have multiple children).
The output pivot table gives for each parent all the children in the children table as in the pictures.
Attached is the sample excel file .
I really don't know what I'm doing wrong here
Please help.
Thanks
Last edited by desoky725; 06-10-2020 at 06:22 AM.
Why not simply add the Parent Name as a 4th column in the Kid Table and use a VLOOKUP in the 4th column to lookup the parent ID in the Parent table?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
This is just a simplified example , it would be real hard to do with all the tables I have.
So I really need to do it with relations between tables
As soon as you add a value field from Table2 the problem will disappear.
Rory
Thank you rorya, that has solved, I can hide the values extra column if I don't need it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks