Measure/dimension with only positive or negative values
I´d like to see all of the positive values in one dimension together compared to all of the negative values. Like you have a currency dimension and you´d like to see all positive values in USD and all negative values and so on for other currencies
What is the easiest way to do this? I am apparaently to stupid to achieve this.
I tried restricted measures but failed since there is no conditon on pos. or neg. values
I tried agreggated measure but there again is no conditon on pos. or neg. values
I tried to key in a if-formula in the calc. editor. This does not work either since it than shows me the net pos. or neg. value or 0 (IF(["Model":Value]<0 ;["Model":Value] ;0 )