Help with Set Analysis

[#1]

Hi Community,

I am trying to create a simple table with many dimesnions one of the dimensions is Status and i want only status as ABC to be shown. But when im writing the set analysis in dimension it is giving me invalid dimension and when im doing it in measure it is giving me null values. Can anyone help me on this ?

[rubenmarin1]

Hi Muntazir, try with

Only({<Status={'ABC'}>} Status)

or

Aggr(Only({<Status={'ABC'}>} Status), Status)

[jagan]

HI,

Try like this

Only({<Status={'ABC'}>} Status)

OR

MaxString({<Status={'ABC'}>} Status)

OR

MaxString({<Status={'ABC'}>} Status)

OR simply give

'ABC' in expression

Hope it helps you.

Regards,

Jagan.

[#4]

Hi,

You can accomplish this without set too. Try the following as a calculated dimension:

If( Status= 'ABC', Status)

Please check suppress null.

Regards

Rahul Lakhina