Is it possible to remove unwanted options from a pivot table splitter?

[tonywatsonhelp]

Hi Everyone,

I always get this problem when i use pivot tables and cant work out how to stop it,

I create a splitter that works great but looks ugly because it includes options that are in the data but not required in the splitter,
is it possible to remove these with vba?

so heres what happend

raw data has a column called "sold As" and i use this as my splitter data

now in this Column i have different names like

"Tony"
"Bill"
"James"
"Sue"
"Joe"

but it also has data like "0" and "N/A"
so my splitter looks like this
"0"
"Tony"
"Bill"
"James"
"Sue"
"Joe"
"N/A"

ow what i woundering is is it possible to filter out the options "0" and "N/A" from the slicer?

any ideas as it just look messy and incorrect as it is

Thanks

Tony

 

[alansidman]

Simply filter out the data in Excel before building the Pivot Table.

 

[tonywatsonhelp]

Thanks Alan,
i try that