List box of the same field not showing the blank value while it is showing in the pivot table?

[joeluqlik]

I have a field that's not showing the blank value within a list box as a choice of selection, but for the same dimension it shows the blank value among other values within a pivot table on the same sheet.  Any help on this?  Thanks!

[Anil_Babu_Samineni]

Can you provide sample

[joeluqlik · Accepted solution]

Thanks, Anil, but I just found the solution on another link in the community by doing this to the field and it worked:

If(isnull (LetterSentDate),'NULL Value',LetterSentDate)  as [New LetterSentDate ]