Show empty values in a pivot table

[#1]

Grettings, I have a problem.

I have a pivot table, like this:

In that that tabla I count the employees that have a termination reason, the count is Count(DISTINCT GlobalEmployeeId). It works perfectly, but, in the dimension Termination Reason, I have four fields, but the fourth,  Transfer Unit, isn't show because the numeric count is null, in other words, no one employee haves that termination reason. Then, Qlikview didn't show that field, and that's my problem, I need to show that field with zeros.

Thanks you for help me, regards!

[rajni_batra]

Uncheck Suppress when value is null from MONTH Dimension..

Hope it Helps!!!

[senpradip007]

Hi

In dimensions - > tick show all values and in presentation tab ,untick suppress zero values..  and also do

Uncheck Suppress when value is null from MONTH Dimension

Hope it helps