In the attached workbook, I have customer name filter.
Aaron Day is selected. Though there is no data, I want empty columns to be visible.
'Show empty rows' and 'Show empty columns' are enabled.
For Aaron Day there is no data.So there are blank cells.
I want 0's in place of blank cells.
Sample.twbx 998.5 KB