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?
Change your Dimension expression to
If(Sum(Revenue) > Threshold, A)
And select "Suppress Null values" checkbox
Can you share any sample data in excel file.
Dear ,
can you attach sample data.
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.
If i understand you can write
Sum( If(Sum(Revenue) > Threshold, Revenvue))
See the attached data. I want to show only those rows if exp1 > Threshold value for given particular client
There are different values for threshold for different dimensions. I guess thats why above logic is not working
But you have two expression Exp1 and Exp2 can you elaborate more with sample data.
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%