not showing pivot values of zero

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

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

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

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

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

Sorry, I should have been clear that I am actually a relatively advanced
user. So I wasn't asking how to use filters. Rather, I thought that there
was some special sort of pivot filter I hadn't heard about. But you brought
up a simple idea which I never even thought of doing before. Specifically, I
never thought of simply putting a filter onto a table sheet. I guess the
fact that you can change so little in a table made me mentally associate
pivots with static status. But you are right that filtering just changes the
hiding property, so that'll do just fine.

Thanks.
--
Boris


"David McRitchie" wrote:

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

Hi Boris,
No problem, the extra few paragraphs will make it understandable
to few other people later on who may not be familiar with pivot tables
or filter.

"BorisS" <BorisS@discussions.microsoft.com> wrote
> Sorry, I should have been clear that I am actually a relatively advanced
> user. So I wasn't asking how to use filters. Rather, I thought that there
> was some special sort of pivot filter I hadn't heard about. But you brought
> up a simple idea which I never even thought of doing before. Specifically, I
> never thought of simply putting a filter onto a table sheet. I guess the
> fact that you can change so little in a table made me mentally associate
> pivots with static status. But you are right that filtering just changes the
> hiding property, so that'll do just fine.

Hi Boris,
No problem, the extra few paragraphs will make it understandable
to few other people later on who may not be familiar with pivot tables
or filter.

"BorisS" <BorisS@discussions.microsoft.com> wrote
> Sorry, I should have been clear that I am actually a relatively advanced
> user. So I wasn't asking how to use filters. Rather, I thought that there
> was some special sort of pivot filter I hadn't heard about. But you brought
> up a simple idea which I never even thought of doing before. Specifically, I
> never thought of simply putting a filter onto a table sheet. I guess the
> fact that you can change so little in a table made me mentally associate
> pivots with static status. But you are right that filtering just changes the
> hiding property, so that'll do just fine.

Sorry, I should have been clear that I am actually a relatively advanced
user. So I wasn't asking how to use filters. Rather, I thought that there
was some special sort of pivot filter I hadn't heard about. But you brought
up a simple idea which I never even thought of doing before. Specifically, I
never thought of simply putting a filter onto a table sheet. I guess the
fact that you can change so little in a table made me mentally associate
pivots with static status. But you are right that filtering just changes the
hiding property, so that'll do just fine.

Thanks.
--
Boris


"David McRitchie" wrote:

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

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

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