drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 543
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance!
I have a TABLE, not a Pivot Table
This table is huge, so I have say 2 Slicers
The First Slicers named "QAZ" shows 3 options:
When the Table is Clear with non filtered data, there a re not blank items for the Column "QAZ", I mean the 1st Slicer named "QAZ" does not show blank items
If I select using the 2nd slicers the option(Blank) then the 1st slicers shows only the posibility "BB"
which is actually OK, because the option BB has some cells with no country
However when the Table is unfiltered if I use the first Slicers to select "CC" or "AA" then I have the possibility to select blank from within the 2nd slicer
but oviously if I select the (blank) option the Table shows nothing
What am I doing wrong and/or how can I avoid the Option (blank) if I know I do not have any
I mean why I am still having the Possibility to select (blank) as country when the Column "QAZ" for the option AA or CC does not have any blank country
ps:
I do not want to Use additional Columns and/or Slicers, VBA and/or
I am trying to know why this is happening
I have a TABLE, not a Pivot Table
This table is huge, so I have say 2 Slicers
The First Slicers named "QAZ" shows 3 options:
AA
BB
CC
The 2nd Slicers named "Country" shows 5 options:BB
CC
Spain
Italy
UK
Ireland
(blank)
Italy
UK
Ireland
(blank)
When the Table is Clear with non filtered data, there a re not blank items for the Column "QAZ", I mean the 1st Slicer named "QAZ" does not show blank items
If I select using the 2nd slicers the option(Blank) then the 1st slicers shows only the posibility "BB"
which is actually OK, because the option BB has some cells with no country
However when the Table is unfiltered if I use the first Slicers to select "CC" or "AA" then I have the possibility to select blank from within the 2nd slicer
but oviously if I select the (blank) option the Table shows nothing
What am I doing wrong and/or how can I avoid the Option (blank) if I know I do not have any
I mean why I am still having the Possibility to select (blank) as country when the Column "QAZ" for the option AA or CC does not have any blank country
ps:
I do not want to Use additional Columns and/or Slicers, VBA and/or
I am trying to know why this is happening