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
>
>
>