How to filter a column

[Anonymous]

Hi All,

I have one field named 'F/I' whose values are F,I

Now I put it into Table dimension, I don't want to show I in this dimension, how to filter it?

[neelamsaroha157]

May be you can filter it out in your expression -

Something like -

Sum({<[F/I] = {'F'}>}YourMeasureField)

[vishsaggi]

Or you can try like in your calculated dimension

= Aggr(IF([F/I] = 'F', [F/I]), [F/I])

[pooja_prabhu_n]

Hi,

try this in calculated dimension and check suppress null value

IF([F/I] = 'F', [F/I])

Thanks,

Pooja