Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i would like to create a table that shows revenues of over x amount and below y amount (e.g 1000<revenue<2000), with the regular dimensions (date, customers, countries etc)
how do i do it?
thanks.
try
TEST:
noconcatenate load
col1,
col2,
revenue
..
resident ActTable
where Revenue > 1000 and Revenue < 2000
you can drop noconcatenate when you donot have a table with same column
I
Try something like this:
Sum({<Revenue = {'>1000<2000'}>}Revenue)
This will only include revenue between that particular range.
HTH
Best,
S
Hi
Expression: =If(Sum(Revenue) > 1000 And Sum(Revenue) < 2000, Sum(Revenue))
And make sure suppress zeros is checked (on the Presentation tab)
HTH
Jonathan
Hi,
Create your graphe with your dimension and the following expression:
if(sum(revenue)>1000 and sum(revenue)<2000,sum(revenue))
it shows a '-' when the sum is different from the range.
i don't want to see these rows, how do i not show them?
It should not show '-'. Have you used the condition in your dimension or expression? If you used it in dimension, you may need to check 'Suppress when Null' option on the dimension tab of the properties.
Can you share the exact dimension and expression that you are using?
Best,
Sunny
it's an expression.
i wrote the line "=If(Sum(Revenue) > 1000 And Sum(Revenue) < 2000, Sum(Revenue))"
in the definition rubric, not the conditional rubric
Look at a sample application. Does this help? (PFA)
Best,
Sunny