View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Zero values in Pivot Tables

How are the zero rows being automatically hidden?

alanas wrote:
1) I am using Excel 2003
2) Yes I have. And "01.03.08" is checked there to be shown. But anyway, that
is not displayed in the Rows field, because "Sales" equals to 0 (in Data
field).
So How can I solve it in PivotTables?

alanas

"Debra Dalgleish" wrote:


What version of Excel are you using?
Do you have a filter on the values?





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html