Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table, showing the count of items where a dimension is null. I checked the "include null values" checkbox to show this.
In the screenshot below, you can see that I am getting the count, and since the dimension is null, a dash (-) is shown.
Any advice appreciated! Thanks.
Did you check if it is a NULL string?
Len(my_value)=0 Or Len(Trim(my_value))=0 Or my_value=''
@Saravanan_Desingh Thank you for your reply. I was able to figure out the first part of my question.
I have an expression where if the dimension value is null, I put in "_Unknown", instead of showing the default dash character.
My second question is this is a pivot table with several fields. Valid values are blurred out below in the screenshot, but it is working as I want. Users can expand using the + icon to see other values.
If the dimension is null, I only want to show "_Unknown" once. Is there a way to turn off the + icons so that users can't expand? Each time they expand, it will always show the same thing, so only need to show it once.