Pivot Table -- Suppress blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Pivot Table, Layout,
Double Click on Row Item, check on "Show items with no data"

Hope that works
Regards
Aqib Rizvi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suppressing #VALUE! in calculated field in Pivot Tbl 1
Blank Suppression 3
Excel Pivot Table row heading (blank) with no data in it 3
Pivot Table - 3
Headings for Sum in Pivot Table. 5
Pivot Table - hide blank cells 1
Pivot Table Calculated Field - Sum/count 1
Pivot table grand total location 1

Back
Top