slicers

Hi there, I am looking on the internet for slicers with sub categories, check even the pivot tables slicers but it sound I can't understand. I need a first slicer with 5 products and than I need below each product another slicer with the sub names. Smth like below: So I need the 1 slice...

I have three pivot tables. 1. Sales 2. GP$ 3. Units Sold I created this individually (not a copy) from the same data source. I created a slicer for each table. However, when I connect the slicers, the pivot tables all turn into the same view, say 'Sales'. Instead of displaying the requested...

Hello Everyone, first-time poster, Basically, I have two different slicers, from two different data cubes, filtering multiple pivot tables on multiple different (hidden) sheets throughout this workbook - the values from these pivot tables are used on the front page of the report. The slicers...

Hello, I am trying to write some code to synchronize two slicers that are linked to pivot tables that were created from a Power Pivot Data Model. I need to do this in the first place, because the data model is not properly working to control all of the tables with defined relationships...

Hello! After the recent virus attack of Petya.A in our company we had to reinstall windows and office. This time we installed all new windows 10 x64 and office 2013 x64. What we encountered is that on some PC's slicers for pivot tables are not visible. This is true for both previously created...

Hi first timer here. I am trying to create a new database from some data that I already have in an excel spreadsheet and I don't know where to start and actually the problem is relatively difficult to explain too! I have multiple data attached to a value in the first cell, but would like to...

I'm building an interactive dashboard with slicers and pivot tables. My challenge is that I have two columns with dates. I need to calculate how many dates in the second column have a future date in the next month based on the referral date. Example below. What I'm trying to achieve is to show...

Hello, I have a database with the following Column Headers: - Client ID - Client Name - Partner ID - Partner Name - Primary Team Member ID - Primary Team Member Name - Secondary Team Member ID - Secondary Team Member Name Each row will have unique values for each column (i.e. a person cannot...

Hello users! I have some slicers connected to graphs in a spread sheet. When I clear a slicer filter I get the warning: "the maximum number of data series per chart is 255". I don't need to rearrange my charts because of this, I just want to disable this warning. I tried several things using...

Hi there, I have a set of dynamic dashboards that are running from a set of pivot tables in version 2016. I sent the dashboards to my customer and they said they were not compatible with their Excel 2010. I tried the backward compatibility procedures that forces me to save my worksheet which is...

I have a slicer that has multiple values. the slicer controls multiple pivot tables. I need to select each value in the slicer and print a PDF. there are 100 values in the slicers and do it manually is a time consuming. how do I automate the process via macros or modules?

I created 2 pivot tables from the same data set & then I created a slicer. The slicer only worked on one of the pivot tables (rather than both at the same time). Does anyone have any idea on how to make it work? Thank you in advance. Also, I'm using "Excel 2016 in Depth..."

Hi, I have a workbook with 3 sheets, "Complaint Chart", "Pivot Tables" and "Pivot Charts". The actual pivot tables, on the sheet Pivot Tables, are created from a dynamic named range from the Complaint Chart sheet. I then have 3 slicers, Year, Day and Type on the Pivot Chart sheet which are...

I am trying to set a Timeline date range using VBA. sub DateTest() Dim sd as Date Dim ed as Date sd = Sheets("Stuff").Range("B11").Value ed = Sheets("Stuff").Range("C11").Value Sheets("Charts").Shapes.Range(Array("Date6")).Select...

Hi all, I am having trouble coming up with code to select the first slicer item creating a PDF, and then deselecting that first slicer item and moving to the next one, creating a PDF and so on until the end of the slicer Is there anyone that can help? Thank you

I have 500,000 rows of transactional level data. I am summarizing into a pivot (ultimately a pivot chart) by month. I have Slicers for Months and 2 different style differentiations. I would like to keep the monthly sum but also add a Monthly Average (averages the sum of each month) that is...

I'm building a dashboards with Pivot tables and slicers. I have shaded the cells green, but when I click a slicer, the cells 'behind' my Pivot Table are white. Any advice on how to control this without VBA?

I have a worksheet that I've created as a Dashboard in Excel 2016. The pivot slicers have shapes around the slicers that make the display more appealing to the end user. I want the shapes and corresponding code behind the shapes not movable/editable by the end users. This also means I don't...

Hi, I have created a pivot table with slicers. I can't quite get the month slicers working. Please see below table which records the number of days that people are absent: The above formula under the total days columns calculates the difference between date from and date to, it excludes...

I have three pivot tables in a workbook, and three slicers on one page next to one of the pivot tables. The pivot tables are all linked to the same data source. The three slicers are linked to the same fields in all three pivot tables (Product, Project & Supplier). I need to connect the slicers...