I have a spreadsheet with data on "coaching" sessions between the managers and the employees. I've converted the data for privacy, so here's a sample of what I have:
Excel 2013 32 bit
<tbody>
</tbody>
<tbody>
</tbody>
I have two pivot tables. The first one shows Employees in the rows, and Supervisors as the columns. I can slice that one without problem. I have slicers for month, employee, and supervisor.
The second lists Call Stats, Sales Stats, Monthly Topic, Training, and Other as columns. I want to be able to slice by those columns, in addition to month, employee and supervisor. In other words, I want to be able to see just the rows where the type of meeting was for training, or training and other.
Is there a way to do this?
Debbie H
Excel 2013 32 bit
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR] | |
---|---|---|---|---|---|---|---|---|---|---|
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR] | Date | Employee | Supervisor | Notes | Call Stats | Sales Stats | Monthly Topic | Training | Other | Month |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR] | 5/1/2018 | John Snow | MOD One | Keep up the great work! | X | X | May | |||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR] | 5/20/2018 | Arya Stark | MOD One | X | May | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR] | 5/20/2018 | John Snow | MOD One | X | May | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR] | 5/20/2018 | Tyrion Lanister | MOD Two | X | May | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR] | 5/20/2018 | Khal Drogo | MOD Two | X | May | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR] | 5/5/2018 | Arya Stark | MOD One | X | May | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR] | 5/4/2018 | Tyrion Lanister | MOD Two | X | X | May | ||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR] | 5/4/2018 | Khal Drogo | MOD Two | X | X | May | ||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR] | 5/1/2018 | Arya Stark | MOD One | X | May | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR] | 4/5/2018 | John Snow | MOD One | X | X | April | ||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR] | 4/21/2018 | John Snow | MOD One | X | April | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR] | 4/21/2018 | Tyrion Lanister | MOD Two | X | April | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR] | 4/21/2018 | Khal Drogo | MOD Two | X | April | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR] | 4/3/2018 | Tyrion Lanister | MOD Two | X | X | April | ||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR] | 4/8/2018 | Khal Drogo | MOD Two | X | X | April | ||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR] | 4/15/2018 | Tormund Giantsbane | MOD One | One week to improve | X | X | X | April | ||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR] | 4/21/2018 | Tormund Giantsbane | MOD One | Termination meeting | X | April |
<tbody>
</tbody>
Sheet: Data |
<tbody>
</tbody>
I have two pivot tables. The first one shows Employees in the rows, and Supervisors as the columns. I can slice that one without problem. I have slicers for month, employee, and supervisor.
The second lists Call Stats, Sales Stats, Monthly Topic, Training, and Other as columns. I want to be able to slice by those columns, in addition to month, employee and supervisor. In other words, I want to be able to see just the rows where the type of meeting was for training, or training and other.
Is there a way to do this?
Debbie H