Null values of a dimension

[ali_hijazi]

Hello

got a pivot table in which a dimension has null values

what I want is show the label 'Others' instead of '-'

is it possible to make this selectable?

please advise

[tresesco]

In the presentation tab define Null Symbol as -'Others'

[djallelsadki]

Hi,

try a transformation in the script like below

if(isnull(dimension),'Others',dimension) as dimension

D.Sadki

[SunilChauhan]

if(isnull(Fieldname),'Others',Fieldname) as Fieldname

or

if(len(Fieldname)=0,'Others',Fieldname) as Fieldname

or

if(len(trim(Fieldname))=0,'Others',Fieldname) as Fieldname

or

if((Fieldname)=' ','Others',Fieldname) as Fieldname

[partenope]

If you need to "select" null values too, you can read the Help searching "NullAsValue"

[SunilChauhan]

ya i am agree with him

NullAsValue A,B;

Set NullValue = 'NULL' ;

you can customize  'NULL' for example 'Blank '