Help me on this!!!

[#1]

Hi all,

Can anyone help me to make filter in table box?

For example i try with  this expression Par_flag='N'

But it 's not working

Please let me know about this.I'm new to this tool

Thanks,

Thiru

[sushil353 · Accepted solution]

Hello,

you can use set analysis.

something like: =sum({<Par_flag={'N'}>}values)

otherwise please explain your issue/requirement.

HTH

Sushil

[Siva_Sankar]

Its not possible to use an expression to filter in the table box object. But you can use a straight table chart instead, maybe with a calculated dimension =if(Par_flag= 'N', Not) Then your can add dimensions or expression as you like. Or you can also use set analysis in all your expressions to limit the results, for example, use flag as dimension and Regards, siva

[advait_thakur]

Hi Thiru,

First of all you cannot take any condition on your Expression in Table Box.

You can choose only Fields in Table Box.

Please let me know what exactly you want to achieve.

Thanks

Advait

[kaushiknsolanki]

Hi,

     Expressions are not allowed in Table Box.

     Instead you can use the straight table. Straight table allows you to put expression.

Regards,

Kaushik Solanki

[#6]

Thanks sushil