conditionnal sum

[sunnybi]

Hi Experts ,

Once again I need your help ! the case may look simple but I can't have the expected results .

In expression D ,in the table below , I'd like to have the total where expression C < 39. 

As you can see , the columns 2 and 3 in the expression D are excluded which is correct , but still haven't found out why the total don't show up. I tried to sum (aggr ( D expression,... ) but still.

the results is ok , in a straight table  : (had to change total properties from auto to Sum ) 

Thank you thousand time for your help

[Clement15]

Hello,

You must use a formula of this form

sum( {<Dimension={"=sum(Measure)<39"}>}    Measure)