Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ok, I can reproduce your issue on V9 32 bit.
This seems to work on this version:
=only({<Date=>} IDProduct)
I think unchecking the option 'suppress zero values' in presentation tab of your table properties should be enough.
Hope this helps,
Stefan
Hi,
Go to table properties, then to Presentation tab, select your dimension and uncheck the option "Supress Zero Values"
It`s not enough.
You also need to check "Show All Values" and "Suppres When Value Is Null" in the dimension sheet.
Please, see the example attached.
I can't use "show all values" because I need filter by supplier.
Ok, what about an additional hidden expression?
=only({<Date=>} 1)
Sorry but this way don't apear product number 2.
Not sure what you mean by 'doesn't appear product number 2':
Try atach again please. Here don't show product 2.