Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
here is my pivot table
dimension:
Product.Name
Expression:
=count(distinct Product.SalesDate)
The table shows only those products which has at least 1 Product.SalesDate. It does not show the Products which have 0 SalesDate.
Can you think of any reason?
Change your expression to
=count(distinct Product.SalesDate) + Sum({1} 0)
HIC
Have you tried to uncheck 'Suppress Zero Values' on the presentation tab?
try this
In dimensions - > tick show all values and in presentation tab ,untick suppress zero values..
and
this also
Did you unchecked it(Suppress when value is null.) for both the dimensions?
yes but it still does not show up.
i did both but i still do not see
Is the count 0 or is it missing?
I think there are NULL values instead of 0 values.
Pls check it in your Data source
i am doing count which will always return a value.
i am trying to see if there is any product which does not have a salesdate.
i do not see any product in the table whose
count(distinct Product.SalesDate) ia 0
If there is no such value then why you are checking it @Jean