Showing null values

[#1]

My question is how to show null values?

I have two tables

Products

------------------------------

IDProduct          Desc

1                    Milk

2                    Cookie

3                    Coffee

Sales

-------------------------------------

Date                    Product                    Quant

03/16/12          1                    20

03/16/12          1                    10

03/16/12          3                    5

03/14/12          2                    10

I made a table to show my results filtering date 03/16/2012

So my result apears:

Product                    Sales

1                    30

3                    5

I need to show

Product                    Sales

1                    30

2                    0

3                    5

[swuehl]

I think unchecking the option 'suppress zero values' in presentation tab of your table properties should be enough.

Hope this helps,

Stefan

[jvitantonio]

Hi,

Go to table properties, then to Presentation tab, select your dimension and uncheck the option "Supress Zero Values"

[#4]

It`s not enough.

[#5]

You also need to check "Show All Values" and "Suppres When Value Is Null" in the dimension sheet.

Please, see the example attached.

[#6]

I can't use "show all values" because I need filter by supplier.

[swuehl]

Ok, what about an additional hidden expression?

=only({<Date=>} 1)

[#8]

Sorry but this way don't apear product number 2.

[swuehl]

Not sure what you mean by 'doesn't appear product number 2':

[#10]

Try atach again please. Here don't show product 2.