Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SET vLNegContribution =if(Sum({<ValueName={'Contribution-margin|Margin'}>}ValueSEK) <0, Sum({<ValueName={'Contribution-margin|Margin'}>}ValueSEK));
Hey Guys,
Above works pretty fine it gives me sum of contribution margin and when it's below 0 it outputs that row. all good.
But i would like to show every row where they have negative contribution margin. Not a sum.
Client can have 10 rows 9 of them are minus but as logn as 1 positive row is larger it wont show.
I can take Market as dimension and it shows right values but if I add client it doesnt give me what I want
Is it possible to do this in one table if you understand?
May be try this:
Sum(Aggr(if(Sum({<ValueName={'Contribution-margin|Margin'}>}ValueSEK) <0, Sum({<ValueName={'Contribution-margin|Margin'}>}ValueSEK)), Market))