Pivot Table -- Suppress blank cells

  • Thread starter Bharath Rajamani
  • Start date
B

Bharath Rajamani

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!
 
A

Aqib Rizvi

Pivot Table, Layout,
Double Click on Row Item, check on "Show items with no data"

Hope that works
Regards
Aqib Rizvi
 
Top