View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alanas alanas is offline
external usenet poster
 
Posts: 7
Default Zero values in Pivot Tables

Hi all,
I have a PivotTable:
1st col: 2nd col:
Dates(Row fields) Sales(Data fields)
01.01.08 100
01.02.08 150
01.03.08 0
01.04.08 120

And that one 01.03.08 row is automatically hidden, because it contains zero
value in its data field, consequently it will not be shown in diagram also.
Could you suggest me How can I show it in my PivotTable (Diagram)? The point
is that it's shown and checked in filter list, but anyway it's not shown in
result PivotTable.
thanks