Where condition in Expression in a Table

[praveen1108]

Hi,

Can any one help me if i have to write a where condition in expression for my Table how can we do that.

I know if we have a measure then we can do Sum({<BU={"Finance"}>} Amount) but without measure how can we do that.

Regards,

PK

[robert_mika]

Can you give an example of what you tying to achieve?

[praveen1108]

I have a data grid or table showing some list of records and i wanted to put a filter where some Dept='Finance' which is a flag.I wanted to do in an expression not in data load Editor

For Example: this is my table and i have some no of records like

SerialNo  Description  Dept      

100          XXX          Finance   

2000        YYY           Support   

and i want to fetch only Dept='Finance'

Regards,

PK

[harsh44_bhatia · Accepted solution]

If you do not wish to do this in expression, the other way is to make dept as a calculated dimension.

if(Dept<>'Finance',Dept) and under the properties of calculated dimension select suppress where value is NULL.

[praveen1108]

Thank you very much harshit..It helped me...