Straight table values

[#1]

Hello everyone,

I have a straight table with a set analysis expression. I would like to show only values that are larger than X. how can I do that?

I tried to change the expression to a dimension (I wanted to add condition and suppress when value is null)  but there's an error in the set analysis calculates dimension.

any other ideas?

Thanks

[alexandros17]

Let's say tour expression is Expr1 then write:

If(Expr1 > X, Expr1, 0)

as default, all zera values are excluded (if you have more than one expression (es. expr2) you have to write in expr2:

If(Expr1 > X, Expr2, 0)

So all expression will turn to zero if expr1 condition is not satisfied

[#3]

you want not to show some rows with small data?

well, for example, if you have an expression (exp) you can change it (or create second one and hide the first one) like

if(exp > X, exp, 0)

rows with this 0 will go away

[#4]

Thanks for the quick response

it's not working(still shows the 0 values) my straight table looks like this:

3 dimensions (HotelID which is a calculated dimension, hotel name and city name)

and the following expressions:

1. Gross LM:  sum(gross)

2. Gross LM same country(the set analysis expression):

sum({1<Agency_Country=P(Agency_Country)>}Gross_LM)

3. flag

i only want to show Hotels where expression No. 2 is larger than X.

[antoniotiman]

Hi,

You need Calculated Dimension like this

Aggr(If(Sum(Gross_LM) > X,HotelID),HotelID,Agency_Country)

Can You share sample data ?

Regards