Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Write like below in expression and change according to your expression
Sum( if(Aggr(sum(Exp1),[Client(Dimension)]) > Aggr(sum(Threshold),[Client(Dimension)]), Exp1) )