ExcelBanter - Pivot Table -- Suppress blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table -- Suppress blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/113372-pivot-table-suppress-blank-cells.html)

Bharath Rajamani

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!

Aqib Rizvi

Pivot Table -- Suppress blank cells

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

Hope that works
Regards
Aqib Rizvi

All times are GMT +1. The time now is 10:55 PM.