Different rules of aggregation on different levels. Please help!

[dima]

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!