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?

[#2]

Write calculated dimension like this

IF((aggr(Sum(revenue),Product)>aggr(sum(threshold),Product)),Product,null())

enable suppress check box,

add the respective expression you would be able to see the result

[its_anandrjs]

Write like below in expression and change according to your expression

Sum( if(Aggr(sum(Exp1),[Client(Dimension)]) > Aggr(sum(Threshold),[Client(Dimension)]), Exp1) )