exclude zero in pivot table

Topic

New Reply

hi,

i have the down pivot data sample and i want to exclude the zero values
DELTA (x-y) DELTA (x-y) Total
fax 1999 2000 2001
akrm 0 0 0 0
adm 0 0 0 0

an ideas…

Reply | Quote

Replies

Not sure of your setup, but autofilter could hide the zero values.

Steve

Reply | Quote

You could try going to the actual data that the PT is based on and create a new column. Call the new column somehting like ZERO. Put a formula in the new Column that identifies when data is zero and returns a value. BY Example if each row in the Data has 11 columns of crieteria some which could be zero, expand the Data to include a new Col 12. Then use a formula such as IF(AND(A10 =0, B10 = 0, C10 = 0),25,0) Copy down.
Run the PT and include the new column as part of the PT. Using above example, after the PT is done filter on the new column to exclude all 25’s. Now your zero’s are filtered out of the PT.

Hope this helps.

Reply | Quote