Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Hello @rushikale0106 ,
Thanks for responding.
Yes it helped me to avoid the '-' but the table still don't display '0' values.
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
Yes, it worked @rushikale0106
Thank you for your help, I really appreciate that.