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?!
In general it is better to use the proposed set expression solution instead of the calculated dimension. It is better for the performance and you will not loose some of the dimension options (like sort). You will indeed have to include the set expression in all expressions (even some of the expessions as background color of the expression.)
Sum( {$<Country={'USA','Israel'}>} Sales)
hope answer the question.
tnx everyone!!!