Hi Boris,
I meant try it on the pivot table results because that is what you are trying
to modify the results of. Which filter -- choose something that works.

Might try making a helper column something like
H1: =SUM(A1:G1)

Or something that recognizes that there are 5 numeric columns
so you don't suppress descriptive information on rows with only titles
H1: =AND(SUM(A1:G1)=0, COUNT(A1:g1)=5)

The helper column would make it simple to use a basic filter.
select column H, data, filter, autofilter
click on the dropdown for the filter in column H and choose False

To get rid of the filter (just as important as knowing how to filter)
Data, Filter, autofiter (will remove the checkmark an the filter) :

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"BorisS" <BorisS@discussions.microsoft.com> wrote in message news:CD0EA23F-C4C4-4B0F-B040-7410F485D1E3@microsoft.com...
> Thanks, David.
>
> Which filter there are you talking about? I see lots, and I am not sure if
> you're talking about one that filters original data or the actual pivot.
> LMK. Thx.
> --
> Boris
>
>
> "David McRitchie" wrote:
>
> > Hi Boris,
> > Did you try filtering the list see Debra Dalgleish's index page
> > http://www.contextures.com/tiptech.html
> >
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "BorisS" <BorisS@discussions.microsoft.com> wrote in message news:1DD652B0-CDC0-43D4-9D46-7A3616FF7255@microsoft.com...
> > > I am getting lots of values in my table which are zero. I have a calculated
> > > item, and don't know if that is the problem. How, if at all, can I get any
> > > line which has all zeros to not show up? the table gets excessively long
> > > with them, not to mention the calculation takes forever.
> > >
> > > --
> > > Boris
> >
> >
> >