Count() in Pivot table

[jduluc12]

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?

[sunny_talwar]

Have you tried to uncheck 'Suppress Zero Values' on the presentation tab?

[Chanty4u]

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?

[jduluc12]

yes but it still does not show up.

[jduluc12]

i did both but i still do not see

[sunny_talwar]

Is the count 0 or is it missing?

[Shubham_Deshmukh]

I think there are NULL values instead of 0 values.

Pls check it in your Data source

[jduluc12]

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.

[jduluc12]

i do not see any product in the table whose

count(distinct Product.SalesDate) ia 0

[Shubham_Deshmukh]

If there is no such value then why you are checking it @Jean