Values showing - in the pivot table

[prashanthd12]

Hi ,

I am having a issue where value in the pivot table for a particular notification number shows  -  as value but when i filter on the notification number i am able to see  quantity value.  can anybody please shed some light on how to go about this. 

After Applying the filter on notification number.

[justISO]

Hi, could you share the expression of your 'Rejected QTY' here - it will be easier to find the problem? I guess you are aggregating, which can cause such behavior.

[prashanthd12]

Hi,

Thank you for the reply.  Below is the snippet of the expression.

[prashanthd12 · Accepted solution]

Sorry i just noticed that the table is using the date which is  auto calendar derieved . I am good with the data. Thanks much for the response