Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have a straight table with two dimensions.
i want that the table will show only two values of one of the dimensions.
lets say-
my dimension 'country'
the values i want to show 'USA' 'israel'
i tried to put in the enable condition: if(country='USA' or country='israel',1,0)
its not working.
can someone help me?!
Use calculated dimension. something like this
If(match(country,'USA','Israel') > 0,country)
Keep in mind that match is case sensitive.
Hi,
Try this if(country='USA' and country='israel',1,0)
Thank you
Vardhan
Use calculated dimension. something like this
If(match(country,'USA','Israel') > 0,country)
Keep in mind that match is case sensitive.
Why don't you use Set Analysis in your expressions?
Place Country as your Dimension and restrict the Country values using Set Analysis.
Try:
Sum ( {$< Country= {'USA', 'israel'}>} ValueField)
A calculated dimension like: If(match(country,'USA','Israel') > 0,country) is the solution you are looking for.
Using just Set Analysis in the expressions, the other values will be listed anyway.
Nope if you only have that expression... If you have more than one expression you only have to place the Set Analysis filters in all the other expressions... It's a different approach.
EDIT... Review the attached file.
and "Suppress When Value is NULL" checked on the Dimension tab. Otherwise you may get three rows.
Peter
Hi Adi,
Two things:
Attached is an example
Thanks
AJ
This is informative. Thanks for sharing it. Didn't know about this.