Pivot Tables-Not Display-Results w/Zero Totals

Hi,

When creating pivot tables is there a way to not include/display those
records where the total equals zero?

The filter option is "grayed" so that must not be an option. Hiding the
zero result rows/columns on the pivot is not an usable option. Not
displaying zeros, still leaves the records remaining data on the pivot and on
any charts.

Any suggestions to try would be greatly appreciated.

Thanks.
--
Linda

You can add that field to the page are, then double click it, this will give
you a list with values, select 0 and click OK

--
Regards,

Peo Sjoblom

(No private emails please)


"Linda" <Linda@discussions.microsoft.com> wrote in message
news:F1BB4F02-DDF8-4372-902C-E78D9D362D8D@microsoft.com...
> Hi,
>
> When creating pivot tables is there a way to not include/display those
> records where the total equals zero?
>
> The filter option is "grayed" so that must not be an option. Hiding the
> zero result rows/columns on the pivot is not an usable option. Not
> displaying zeros, still leaves the records remaining data on the pivot and
> on
> any charts.
>
> Any suggestions to try would be greatly appreciated.
>
> Thanks.
> --
> Linda
>

Sorry, should have been "page area", in the wizard layout drag the
calculated field to the page area as well

--
Regards,

Peo Sjoblom

(No private emails please)


"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:%230IsLQhaFHA.2884@tk2msftngp13.phx.gbl...
> You can add that field to the page are, then double click it, this will
> give you a list with values, select 0 and click OK
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "Linda" <Linda@discussions.microsoft.com> wrote in message
> news:F1BB4F02-DDF8-4372-902C-E78D9D362D8D@microsoft.com...
>> Hi,
>>
>> When creating pivot tables is there a way to not include/display those
>> records where the total equals zero?
>>
>> The filter option is "grayed" so that must not be an option. Hiding the
>> zero result rows/columns on the pivot is not an usable option. Not
>> displaying zeros, still leaves the records remaining data on the pivot
>> and on
>> any charts.
>>
>> Any suggestions to try would be greatly appreciated.
>>
>> Thanks.
>> --
>> Linda
>>
>

Thanks Peo...this works perfectly and is so simple!

Linda

"Peo Sjoblom" wrote:

> You can add that field to the page are, then double click it, this will give
> you a list with values, select 0 and click OK
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "Linda" <Linda@discussions.microsoft.com> wrote in message
> news:F1BB4F02-DDF8-4372-902C-E78D9D362D8D@microsoft.com...
> > Hi,
> >
> > When creating pivot tables is there a way to not include/display those
> > records where the total equals zero?
> >
> > The filter option is "grayed" so that must not be an option. Hiding the
> > zero result rows/columns on the pivot is not an usable option. Not
> > displaying zeros, still leaves the records remaining data on the pivot and
> > on
> > any charts.
> >
> > Any suggestions to try would be greatly appreciated.
> >
> > Thanks.
> > --
> > Linda
> >
>
>