Show dimension when expression value is null

[#1]

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?

Thank you!

Robyn

Sun               10

Mon    

Tues               15

Wed               20

Thurs               5

Fri                    11

Sat                    22

[#2]

=if(isnull(sales),0, sales)

[anbu1984]

Deselect "Suppress when value is null" in Presentation tab

[PrashantSangle]

Hi,

Create Master Calendar to solve the issue.

Regards

[Anonymous · Accepted solution]

Robyn,

In dimensions tab:

- check "show all values"

- uncheck "supress when value is null"

In presentation tab:

- uncheck "supress zero values"

Marc.