View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sumanthkaka Sumanthkaka is offline
external usenet poster
 
Posts: 7
Default Pivot table data need to show zero even no data under column

I am using pivot table data it contains 2 rows one is dealer and other one
is product & there are some sales persons selling that product which was in
page, Now all the sales persons cant sold all the product then also I need
Data as 0(Zero) under column