Thread: Pivot Table -- Suppress blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bharath Rajamani Bharath Rajamani is offline
external usenet poster
  
Posts: 41
Default Pivot Table -- Suppress blank cells
My pivot table suppresses blank rows (i.e. when "Sum of .." Total = 0). Is
it possible to change this to show the respective row with "0" in the Totals
column if no records exist for that selection.

TIA!


Reply With QuoteReply With Quote