Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Can you give an example of what you tying to achieve?
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
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.
Thank you very much harshit..It helped me...