Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi Muntazir, try with
Only({<Status={'ABC'}>} Status)
or
Aggr(Only({<Status={'ABC'}>} Status), Status)
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.
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