Hide part of Pivot Table
 

Is there a way to hide entire rows and columns of a pivot
table if the total at the row or column end is zero?

TIA

Ben

Other than removing the row manually once the pivot table
is established, the way I would do it automatically is by
adding a column to the source data with a conditional
formula.

The header name (lets call it "person") which contains
values for which you'd like to exclude zeros corresponds
to a column of data that the pivot table reads from which
has the header name used in the pivot table. It then
totals yet another column in the source data(lets call
it "amount by person"). I'd add a column which looks at
the "person" column with a formula which says only place
the person's name if the value is greater than zero
(say "null" if value is 0). Then the pivot table should
reference the new column instead of "person", and the
table can exclude "null" from the report(by dbl clking on
the field name and unchecking "null").

hth,
Dave
-----Original Message-----
Is there a way to hide entire rows and columns of a pivot
table if the total at the row or column end is zero?

TIA

Ben
.