Can you attach some workbook, It is easy to help with that .

Thanks

Deepak

Without having 3 in the data, there is no way to have "three", there might be some workarounds but first of all, without understanding the full scope of your request and data structure, we cannot answer.

Simple answer for very specific fragment does not make sense in many case.

Thanks,

Shin

Hi Ni,

You should have some value  in data for 3 to make it appear in the view. Even if you have some other values except for 1 and 2, you can update the calculation to

if [Data]=1 THEN "one"

ELSEIF [Data]=2 THEN "two"

else "three"

END

apart from this I don`t think that you will get this result directly.

Soham

Again, without understanding your whole project, these discussion does not make sense.

for example

Thanks,

Shin