How to add nulls values to Others using set analysis.

[Anonymous]

Hi all,

I have a dimension called state which contains values like CA, NY, Others, nulls.

I have a measure called salse. I want to add all the salse value to Others category while creating a bar chart.

Can anybody help me to handle this?

[shraddha_g]

do you have access to load script?

[prat1507]

Use the below in your dimension:

if(state='CA' or state='NY',Others)

Regards
Pratyush

[Anonymous]

no

[Anonymous · Accepted solution]

Thanks prat1507  it worked this way 

if(isnull(state),'Others',state)

[prat1507]

Welcome