Is it Possible to Slice a Pivot Chart by Multiple "Columns" of Data?

dhunton

New Member
Joined
Apr 14, 2016
Messages
48
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
[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]​
DateEmployeeSupervisorNotesCall StatsSales StatsMonthly TopicTrainingOtherMonth
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​
5/1/2018​
John SnowMOD OneKeep up the great work!XXMay
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​
5/20/2018​
Arya StarkMOD OneXMay
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​
5/20/2018​
John SnowMOD OneXMay
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​
5/20/2018​
Tyrion LanisterMOD TwoXMay
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​
5/20/2018​
Khal DrogoMOD TwoXMay
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​
5/5/2018​
Arya StarkMOD OneXMay
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​
5/4/2018​
Tyrion LanisterMOD TwoXXMay
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​
5/4/2018​
Khal DrogoMOD TwoXXMay
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​
5/1/2018​
Arya StarkMOD OneXMay
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​
4/5/2018​
John SnowMOD OneXXApril
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​
4/21/2018​
John SnowMOD OneXApril
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​
4/21/2018​
Tyrion LanisterMOD TwoXApril
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​
4/21/2018​
Khal DrogoMOD TwoXApril
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​
4/3/2018​
Tyrion LanisterMOD TwoXXApril
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​
4/8/2018​
Khal DrogoMOD TwoXXApril
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​
4/15/2018​
Tormund GiantsbaneMOD OneOne week to improveXXXApril
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​
4/21/2018​
Tormund GiantsbaneMOD OneTermination meetingXApril

<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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

dhunton

New Member
Joined
Apr 14, 2016
Messages
48
P.S. Sorry about the format. It looked fine in the preview of the post. :(
 
Last edited:

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,707
You Slice by Fields.
Whether you are using the Filters or Slicers to apply your desired selections, you should be getting your desired results.
Sometimes it seems best to filter at the Page level of a Pivot Table, but then you don't really see on the Pivot Table that Field, especially if using Multiple selections. In some cases i create a Helper Field which is just a duplicate so I can get that in the Pivot Table too.
 

dhunton

New Member
Joined
Apr 14, 2016
Messages
48
The problem here is that I want one slicer showing multiple fields/columns.
 

dhunton

New Member
Joined
Apr 14, 2016
Messages
48
Does anyone know if this is possible?

It would also be useful for something like categorizing a movie list, where a movie can be a comedy, adventure, and historical... or it could be just one of those.
 

dhunton

New Member
Joined
Apr 14, 2016
Messages
48
I still haven't found a way to do this. I know there are all sorts of ways to tweak Excel. I even found a way to apply a slicer to pivot tables from two different data sources.

But I can't figure out how to do this. If there's a way to list the topics/types of "coachings" other than separate columns for each type, I'd be willing to do that. But some coachings have more than one thing that is discussed.

There are so many people here who have done amazing things with Excel. Someone has to have done something like this.

Any help at all would be appreciated.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,501
Messages
5,529,240
Members
409,857
Latest member
KailuaTown
Top