Do not display "0" value

M

Mark

On my pivot table, I have many records that do not have
any value (or "0" value). I do not want the entire record
to show up in my pivot table if there is a zero value. In
Access, you would put this in the critia of a query, but
in a Pivot Table, I"m lost....

Thanks....
 
F

Frank Kabel

Hi
if this is a row / column item you could deselect 'zeros' in the drop
down listboxes
 
D

Debra Dalgleish

Add that field to the Page area
Double-click on the field button in the page area.
In the Hide list, select 0, click OK
 
A

AlfD

Hi!

In the pivot table wizard (Layout section) there is an option t
show/not show items with no data for each field. Double-click on
field name to display this.

Is this what you are looking for in the case of blank entries?

For zeroes (which can of course be meaningful data in some situations
I think you might better look (if you can) to deal with them befor
they get to the pivot table. Maybe they could be constrained to b
blank?

eg by using =if(a1<>0.a1,"") or =if(a1<>0,a1,NA()).

Al
 
M

merlin68

thanks Alf, however it´s not convenient for me due to :
option to show / hide no data cells is not valid for calculated cells, or perhaps I´m wrong ?
I can´t influence database - it´s on mainframe and have to accept what is there.
And last one : I was wonder only if it´s possible to do it fast and without special rules.
BTW : do you know about the way how to retrieve data into pivoty which is locked as form ? Example: I have the form and I need only to uodated daily data in cells but in the certain positions, because pivot changes rows after the upate.
thanx / m68
 
Top