Partial Sums < 0 ?

[selcukcadir]

Hi all,

How can we solve the problem in the attached document?

Thanks...

[#2]

I quite did not understood your question, but I assumed you are trying to filter the records whose sub totals are greater than 0. Please use the below expression in your chart

if(aggr(sum(Sales),LIFNR) < 0, sum(Sales), null())

[selcukcadir]

hi,

I've tried. did not work.

[#4]

I made the change to the below chart

[Anonymous]

try it

sum(aggr(if(sum(TOTAL<LIFNR> Sales) < 0, sum(TOTAL<LIFNR> Sales) ),LIFNR))

[selcukcadir]

Thanks Diego..

But,

1 LIFNR - 2 WAERS >>>>>> In the case where. did not work.

[Anonymous · Accepted solution]

see it

[selcukcadir]

Thanks a lot!... Diego