Hi everyone,
I have been trying to solve this problem for weeks and have not been able to find a solution.
I hope someone might have an idea that has escaped me. I have searched through old posts but cannot find a solution.
I am using Excel 2010 on a computer running Windows 7.
I have an extensive table which lists all information regarding trainings that are run at a company.
It includes many more fields than I have included below, but I hope this can demonstrate the problem.
The table feeds several pivot tables which provide statistics and forecasts.
I am trying to create a pivot table which shows scheduled training (training status: 'scheduled').
I have been able to create one which shows scheduled trainings, in a monthly format, like a calendar,
but it shows participant number, not unique trainings.
How can I show unique trainings?
I have read I could do this by making an extra column, and then counting unique values, but i canno think of any way
to create such values that are unique for each training yet are the same for all participants of one particular training.
The problem is that several trainings can run at once, even for the same topic. There can he between 1 and 6 participants per training.
<tbody>
</tbody>
I would appreciate any advice.
Kind regards,
Kat
I have been trying to solve this problem for weeks and have not been able to find a solution.
I hope someone might have an idea that has escaped me. I have searched through old posts but cannot find a solution.
I am using Excel 2010 on a computer running Windows 7.
I have an extensive table which lists all information regarding trainings that are run at a company.
It includes many more fields than I have included below, but I hope this can demonstrate the problem.
The table feeds several pivot tables which provide statistics and forecasts.
I am trying to create a pivot table which shows scheduled training (training status: 'scheduled').
I have been able to create one which shows scheduled trainings, in a monthly format, like a calendar,
but it shows participant number, not unique trainings.
How can I show unique trainings?
I have read I could do this by making an extra column, and then counting unique values, but i canno think of any way
to create such values that are unique for each training yet are the same for all participants of one particular training.
The problem is that several trainings can run at once, even for the same topic. There can he between 1 and 6 participants per training.
Participant | Training | Training Status | Training Start | Training End |
John Jones | Topic 1 | Scheduled | 01.10.2014 | 05.10.2014 |
Tim James | Topic 2 | waiting list | ||
Tom Michaels | Topic 2 | Completed | 01.04.2014 | 05.04.2014 |
Dawn Marks | Topic 3 | waiting list | ||
Tim James | Topic1 | Scheduled | 16.12.104 | 21.12.2014 |
Jeff Nichols | Topic 1 | Scheduled | 01.10.2014 | 05.10.2014 |
Dawn Marks | Topic 1 | Scheduled | 16.12.104 | 21.12.2014 |
<tbody>
</tbody>
I would appreciate any advice.
Kind regards,
Kat