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!
|