Pivot Table Value Filter won't work

[boernecheryl]

I'm using Excel 2007 to analyze sales data for my territory managers. My database is 21 columns by 39,078 rows (in case this matters.)
My pivot table will not allow me to use the value filters - all options are greyed out except "top 10". I need to be able to exclude the accounts with zero sales dollars. How can I get the value filter option to work for me?

 

[texasalynn]

is the workbook protected or shared?

 

[boernecheryl]

No, it is neither protected nor shared.

 

[texasalynn]

take a look at this
http://www.mrexcel.com/forum/showthread.php?t=346402&page=3

 

[boernecheryl]

OMG I LUV U!!! You have NO IDEA how frustrated I was!!!
YIPPEE!