Comparing with parameters

[rsdhavle]

I have following scenario:

A is my dimension and has values like S1, S2, S3, S4..

B is expression calculating Sum(Revenue)

C is my threshold parameter which contains values  For A dimension lets Say for S1 - Threshold value is 25, for S2 is 50 and S3 - 75 and so on..

I need to display values in B only if value of B is greater than value of C..how can i implement this?

[anbu1984]

Change your Dimension expression to

If(Sum(Revenue) > Threshold, A)

And select "Suppress Null values" checkbox

[its_anandrjs]

Can you share any sample data in excel file.

[mdmukramali]

Dear ,

can you attach sample data.

[rsdhavle]

When i try this logic in expression its is not working and gives all zero values. As you have written i am trying to write it in dimension rather than expression. Lets see if it works.

[its_anandrjs]

If i understand you can write

Sum( If(Sum(Revenue) > Threshold,  Revenvue))

[rsdhavle]

See the attached data. I want to show only those rows if exp1 > Threshold value for given particular client

[rsdhavle]

There are different values for threshold for different dimensions. I guess thats why above logic is not working

[its_anandrjs]

But you have two expression Exp1 and Exp2 can you elaborate more with sample data.

[rsdhavle]

Yes I have 3-4 expression which gives me certain values. Now lets say for client A the threshold is 50. Then I want to show only those rows from expressions which are showing values more than 50%