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]

The attachment works for me.

I see you are using 64bit version, while I am working on 32bit right now. Which version are you using, QV11?

[#3]

Version 9.00 (x64)

[swuehl · Accepted solution]

Ok, I can reproduce your issue on V9 32 bit.

This seems to work on this version:

=only({<Date=>} IDProduct)

[#5]

it's not working for me neither.

[#6]

Thank you very much friends!

[#7]

How can I show the same result using pivot table?

In pivot table I can't hide expressions.

Thanks!