Home |
Search |
Today's Posts |
#1
|
|||
|
|||
advanced filtering in XLS
Hi all,
i'm stuck in creating a report/pivot table. I do not know how to find info on the net since it is hard to explain for a database-newbie. But i think it is not that difficult to create it. But I do not know how to do it in xls and am unexperienced in Access. Here we go: i want to have a report where I have all owners of CD1 CD2 and CD3, their name and then all other CDs they own. I have a list with all names mentioned multiple times in column A and the CD title they own in column B. the pivot tablle should look like : column 1 : the filter on the eg 5 CD titles. comlumn 2 : the name of the owner per CD title column 3 : all CDs this person posesses (including the one mentioned in column 1). The tricky part is column 3 : filter the name of the owner on CD in column1 but show all CDs of the owner which owns the CD in column 1. Anyone can help? Tina |
#2
|
|||
|
|||
If you put CD in the first position in the row area, you would only see
that CD if you were able to repeat the CD field in the third position. You could create a second pivot table, based on the first one, and show the names, with all their CDs, in that one. Tina wrote: Hi all, i'm stuck in creating a report/pivot table. I do not know how to find info on the net since it is hard to explain for a database-newbie. But i think it is not that difficult to create it. But I do not know how to do it in xls and am unexperienced in Access. Here we go: i want to have a report where I have all owners of CD1 CD2 and CD3, their name and then all other CDs they own. I have a list with all names mentioned multiple times in column A and the CD title they own in column B. the pivot tablle should look like : column 1 : the filter on the eg 5 CD titles. comlumn 2 : the name of the owner per CD title column 3 : all CDs this person posesses (including the one mentioned in column 1). The tricky part is column 3 : filter the name of the owner on CD in column1 but show all CDs of the owner which owns the CD in column 1. Anyone can help? Tina -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Auto Filtering | Excel Worksheet Functions | |||
Advanced filtering in Excel to find records ending in xxx? | Excel Discussion (Misc queries) | |||
Advanced Filtering | Excel Worksheet Functions | |||
Advanced Filtering | Excel Worksheet Functions | |||
extracting numbers with no more than 8-digits using advanced filtering | Excel Worksheet Functions |