Sub totals not working when using IF statements in chart expression

[#1]

I can not get a chart expression to subtotal in the attached example.

Am I doing something wrong?

See attached simple example.

[Miguel_Angel_Baeyens · Accepted solution]

Hello Adrian,

You have two options, adding condition within aggregation function:

=SUM(IF(B>'01/09/2010', C))

or using set analysis (preferably):

Sum({< B = {">$(=Date('01/10/2010'))"} >} C)

Hope that helps.