View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dinesh
 
Posts: n/a
Default Pivot table-How to exclude zero values from it.

Hi Friends:

I would greatly appreciate if some know how to fix the below two questions.

What cause the zero amounts to be populated in Pivot table despite you
choose to not to show?

Also, in tha advance function when you choose top 10, sometimes it gives
more than 10 listing in Pivot table. How to fix this?

Thanks a lot.
Dennis