I have a straight table where I am simply showing sum of sales for the days of the week. If there are no sales for a day of the week, like Monday, how can I force that day to appear with no data or zero?
Deselect "Suppress when value is null" in Presentation tab
Create Master Calendar to solve the issue.
In dimensions tab:
- check "show all values"
- uncheck "supress when value is null"
In presentation tab:
- uncheck "supress zero values"
Retrieving data ...