slicer connections

Hello, I have about have about 3 years worth of sales data and I'm comparing in-store to online sales. I summarized my data in a pivot table and included two slicers to easily click on a year and month to view the total sales for that period. I'd like to use a graph to show a visual of this...

Hi guys, I am currently not able to connect the various charts i have created on my dashboard to the same slicer filter I added. For some reason, Only the first Pivot table shows up when I click on 'Report connection. I have tried to fix it with some of the solutions shared on this Thread but...

Hello, I am trying to add multiple slicers to the worksheet, but my code is only adding either one or the other. Each slicer has a different pivot table coming from different worksheets within the workbook. How could I get it so that when the below code executes both slicers are added to the...

Hey Everyone, I am trying to attach a slicer to 2 Pivot Tables based on different data sources. I am following the method as shown in this Youtube video https://youtu.be/p9VD0rsC_bk . I am using it as a guide for my own excel spreadsheet. For my own spreadsheet, I have ticked the box where it...

Hi All, I could really use some help before I go jump off a bridge. Jk. The issue I am currently having it related to using relative references in the GETPIVOTDATA function and cascading slicers. I have a PivotTable set up that has a list of students and their test scores. What I would like to...

HI ALL!! HELP ME PLEASE! 1) I am trying to create a separate Pivot Table for each pivot items using the below code. PivotTable Name = PivotTable_UBT Filter Item = Building ActiveSheet.PivotTables("PivotTable_UBT").ShowPages PageField:="Building" 2) Now i want to connect all the pivottables...

Hello Everyone, I have 2 set of data table. 1 data tables showing day wise sales and another data tables showing day wise discounted sales status. So, what I want to see that every day total sales vs. total discount status. Both the data table headings are same. So, what I did that I put those...

Hi, I'm new to all this VBA coding so forgive me because I know this question has been around in various guises before but I cant find the code to do exactly what I need to do. Here goes... I have a workbook with the worksheets named Complaint Chart, Pivot Table, Pivot Charts. I run a user...

I would like to filter pivot tables with one slicer, i.e. when I pick apples 1lb on the PO pivot table, only that product will be visible on the batch tkt pivot table. The pivot tables all have separate data sources (but the data and pivot tables could all be on one worksheet if necessary)...

Hi Excel Experts! I am running Excel 2010. I have a raw data set consisting of about 31000 rows and 10 columns. In my columns, month, year, product details, volume, sales etc. I have created a dashboard with 6 different charts connected to separate pivot tables, where the pivot tables are...

Hello all, I have trawled the internet (including this forum) for a solution I could not find. Sorry if it's buried somewhere in the forums here and I simply wasn't thorough enough. I've been working on three different workbooks that build out a model R.data -> PQ -> PP -> dashboards. All were...

I have three slicers on a dashboard that are connected to 7 pivot tables. Occassionally when the workbook is opened the pivot table table connections in the slicer are unchecked. I've been unable to re-create this problemly successfully. Are there known issues that I should be aware of.