not showing pivot values of zero

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.

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

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.