View Single Post
 
Old 02-28-2019, 08:01 PM
kyingh kyingh is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2019
Posts: 3
kyingh is on a distinguished road
Default Create a master slicer

Hello all,

I would like to know if it is possible to create a master slicer(or filter) from a range of slicers created from pivot table.

I have created a trend chart of revenue based on 4 different metrics such as Direction(Inbound,Outbound), Payor(Local,Offshore), Segment(SME, Large, Global) and Weight(Heavy,Medium,Light). Currently I can filter based on any of the 4 metrics, But I am unable to look at the trend for 1 specific slicer.

For example, I cant see the trend just for Direction. Thus the idea of inserting a master slicer for the 4 metrics. Is this achievable? Or am I missing a simpler solution?

Thanks!
Reply With Quote