ChrisDenyer
New Member
- Joined
- May 19, 2014
- Messages
- 4
Hi,
I've often used Pivot Tables for databases where you aggregate values, like counting up your sales figures for the month of March and relating them to each sales rep.
However, I want to create a database which keeps a record of training courses in relation to staff members, so I can see which courses are due to expire and who went on those courses at the time and will thus need to retrain.
I can create the tables, create the links between them (I'm using Excel 2013, currently without PowerPivot) and set up a Pivot Table containing those links.
However, it seems Pivot Tables always need to be aggregating something. I can ask it how many courses each staff member has done (because it's a sum), I can ask how many staff members attended each course (another sum) and how many courses are due to expire soon (another sum). But I can't get it just to list the courses.
If I were using SQL I would just have done a SELECT query, but I'm lost as to how to do it in Excel.
EDIT:
My tables, simplified, are as follows:
COURSES
CourseID, CourseName, CourseExpiry
PEOPLE
PeopleID, PersonName
LINKER
LinkID, CourseID, PeopleID
The last table stores the link between the people and the courses
I've often used Pivot Tables for databases where you aggregate values, like counting up your sales figures for the month of March and relating them to each sales rep.
However, I want to create a database which keeps a record of training courses in relation to staff members, so I can see which courses are due to expire and who went on those courses at the time and will thus need to retrain.
I can create the tables, create the links between them (I'm using Excel 2013, currently without PowerPivot) and set up a Pivot Table containing those links.
However, it seems Pivot Tables always need to be aggregating something. I can ask it how many courses each staff member has done (because it's a sum), I can ask how many staff members attended each course (another sum) and how many courses are due to expire soon (another sum). But I can't get it just to list the courses.
If I were using SQL I would just have done a SELECT query, but I'm lost as to how to do it in Excel.
EDIT:
My tables, simplified, are as follows:
COURSES
CourseID, CourseName, CourseExpiry
PEOPLE
PeopleID, PersonName
LINKER
LinkID, CourseID, PeopleID
The last table stores the link between the people and the courses
Last edited: