• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel 2010 - Slicer

M

martinpaiva

New Member
Hello,


I wanted to know if its possible to remove the value (blank) from a Slicer.

I get this value because the source of my pivot table is Excel table from (for example) A3:E3 to A2000:E2000.

The user will be populated each row with information on differents days,so the empty records that i want to filter using the slicer are show as (blank)
 
Good day martinpaiva


Filter on the data containing the blank cells and deselect blanks and then refresh the PT.

An upload of data to some thing like Dropbox would help
 
Hi bobhc,


I uploaed the file that I'm using in the following link:

https://dl.dropboxusercontent.com/u/85562478/CONTROL%20STOCK.xlsm


There you can find 3 Tabs...

"Reporte Stock" is where I have the Pivot tables, two of the three tables get information from the tab "Asignacion Prenda".


I that sheet "Asignacion Prenda" the user will add day a day information.
 
Hi martinpava


As all your pivot table is showing zero (blank)data until the users start entering data so will the pivot charts, about the only advice I can give is to select a slicer and then form the options tab choose the slicer setting and hide all blanks
 
You must log in or register to reply here.
Back
Top