Pivot Tables-Not Display-Results w/Zero Totals

L

Linda

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

Peo Sjoblom

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

Peo Sjoblom

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 said:
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)
Click to expand...
 
L

Linda

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

Linda

Peo Sjoblom said:
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)
Click to expand...
 
Top