Display specific values with 0 values

[KaisGarci]

Hello everyone, 

I am trying to create a pivot table. there is a row that I want to display only a specific value and its sales. I am doing this ' =if(SEGMENT='TRE',SEGMENT) ' in Add calculated dimesion and I am checking supress when value is null. The problem is that the 0 values are not displayed while I want to display them. And when I don't check Supress when value is null it show me the '-' as shown in the picture. 

Can anyone help me with this please ?

Thank you

[rushikale0106 · Accepted solution]

Hello @KaisGarci ,

The following expression might help you with the Suppress Null value which is showing '-' if its null.

=if(isnull(column_name), 'Other', column_name_or_anything_you_want_to_display) 

It will solve your query with suppressing null values with a different values.

Let me know if I am misunderstanding your query and give some more details on your question.

And if it solves your query, mark the answer as Solution which might help others.

Regards,

Rushi

[KaisGarci]

Hello @rushikale0106 , 

Thanks for responding.

Yes it helped me to avoid the '-' but the table still don't display '0' values.

[rushikale0106 · Accepted solution]

Hi @KaisGarci ,

Glad to help.

Try to uncheck the boxes given in the image. It might be restricting your values to display 0 values.

I tried it in my system, it worked with it.

If it does not solve your query, let me know the question in more detail.

Thanks & Regards,

Rushi

---

[KaisGarci]

Yes, it worked @rushikale0106 

Thank you for your help, I really appreciate that.