slicer pivtotable buttons

I've been trying to make this happen but I can't seem to get it right. I have a long table from row 16 (3,000+ lines) and I want to filter out the data by using slicers. The small table from B2 to H9 is what I want to make into a slicer. I tried making a pivot but it's calculating the total...

Hello Message Board. I created a Pivot Table in Excel 2010 that shows Country, Region, Office Sales Rep and Sum of $Sales. I inserted a slicer to to Filter Region and Sales Rep. The problem is that the Slicer shows up, but I'm unable to select anything or even move the slicer to a different...

Morning all (well its morning here) :) I have a pivot table that I need to make change from SUM to Average depending on what slicer button is selected. Initially I had a few issues in that the code caused an endless loop, however I solved that by adding Application.EnableEvents = False at the...

Hi All, I have been using Microsoft Excel 2010 Pro Plus 32 bit. But recently, I shifted to Microsoft Excel 2013 Pro Plus 64 bit. Usually, I see six drop zones (Slicers Vertical, Slicers Horizontal, Report fIlter, Column labels, Row labels, Values) in the PowerPivot's Pivot table in Excel 2010...

Hello, I have a dashboard with three different views (level 1, level 2, and level 3) each on their own separate worksheet. Each worksheet has its own month slicer for the pivots associated with that view. Each slicer is connected to about ten pivots, none of which overlap with eachother (i.e...

Hey ladies and gents, back again with another question. My question pertains to a slicer on a pivot table. Unfortuantly, people using the slicers arent that comfortable with them and asked for an "all option" instead of using the clear filter button to see all the fields in the slicer. Is there...