L
Lynne
Hi.. I would like to know how to eliminate zeros in a pivot table...
Lynne
Lynne
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul
Lynne said:Hi.. I would like to know how to eliminate zeros in a pivot table...
Lynne
Same as in a worksheet:
Tools > Options > View tab, uncheck "Zero values".
R
Roger Govier
Hi Lynne
on the sheet where you Pivot Table appears choose
Tools=>Options=>General and remove the tick from Zero values
on the sheet where you Pivot Table appears choose
Tools=>Options=>General and remove the tick from Zero values
L
Lynne
Hi Roger and Paul,
Guess i worded it incorrectly... if value off all fields in the data
section is zero i would like the entire row to be eliminated.
Lynne
Guess i worded it incorrectly... if value off all fields in the data
section is zero i would like the entire row to be eliminated.
Lynne
R
Roger Govier
Hi Lynne
Using the drop down arrow for the item selected as the row variable,
de-select the value that gives rise to the zero results.
Using the drop down arrow for the item selected as the row variable,
de-select the value that gives rise to the zero results.
L
Lynne
Hi... thanks Roger..
Roger Govier said:Hi Lynne
Using the drop down arrow for the item selected as the row variable,
de-select the value that gives rise to the zero results.