Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 03-01-2019, 12:26 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 436
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

Without example workbook I'm not sure what exactly you want to do. Do you want to display on graph data from any of source table columns used as filter condition? Then add into source table additional (hidden) column(s) with cells linked to data in filter condition columns. In pivot table use added columns in Data section.
Reply With Quote
  #3  
Old 03-01-2019, 02:17 AM
kyingh kyingh is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2019
Posts: 3
kyingh is on a distinguished road
Default

Ive attached a sample file for your reference.

On the Dashboard sheet, I connected the Line chart to 4 slicers. But is it possible to have 1 master slicer to only see the figures of Segment, for example.

In other words, I would like to deselect all other 3 slicers when I select Segment.
Attached Files
File Type: xlsx Sample.xlsx (30.8 KB, 3 views)
Reply With Quote
  #4  
Old 03-01-2019, 03:51 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 436
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

Do you mean, that on sheet Pivot, you can select All for PAYOR, DIRECTION and WEIGHT_TYPE, and set a filter for SEGMENT to specific one - and on sheet Dashboard you can't?

Select all choices in group one-after-one holding Ctrl key down!
Reply With Quote
  #5  
Old 03-02-2019, 11:24 PM
kyingh kyingh is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2019
Posts: 3
kyingh is on a distinguished road
Default

Hmmmm, I guess I am complicating things here. Probably the only way around is to select all other 3 slicers, and select the specific category in Segment, if I want to see the figures for Segment.

I know it doesn't make sense to you or seem confusing. That's because I sort of confused myself as well. Hahahaha.

Thanks for your time anyway!
Reply With Quote
Reply

Tags
pivot table, slicer 2010 2016 excel

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to follow instructions to create master document: error seanspotatobusiness Word 7 04-10-2018 06:42 AM
Create specific documents from a master document DougWBI Word 4 12-19-2016 06:56 AM
Create scope-specific plans from Master Template BobbyG Project 3 04-08-2015 06:15 AM
Create master document using over 100 subword forms efuller Word 3 12-04-2013 09:38 PM
how to create MASTER and SLAVE text hady87 Word 2 10-29-2013 02:31 PM


All times are GMT -7. The time now is 10:09 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft