I am using Sample-Superstore data set to state the scenario and its solution.
Let’s first create a table which have Categories in columns and days of Order date as rows showing Profit. Filter out it for one month of a year, so I am showing data for December 2014.
There are missing values on few days for one or two categories.
Suppose if there is a requirement to show only one row for 27th Dec, let’s do it by creating a calculated field:
So see what happened, the Categories which have NULL value are not getting displayed. If we want to display all categories, whether it has value or it is empty:
Follow below steps:
Go to Analysis Tab -> Table Layout -> Show Empty Columns
Similarly we can do for Empty rows also.