Dear colleagues,
I have a problem. I need to aggregate rows on 3 different levels. On the finest one I need to exclude one value it should be 0, but it should be calculated on other ones with its real value.
I tried to use expression as:
if([some_column] = 'abc') then (0)
else(
[some_column_value]
)
My result is, that is filtered on all levels, not only on finest one.
Have a nice day!