Conditional aggregate

[#1]

Hi All,

I have the following expression which works fine: "=Sum(Aggr(FirstSortedValue([Loan($)],-Date),[Grower No.])) ". In my data, I have a column with "Year" in it. How can I tweak the expression so that it only sums up where Year = 2014 for example. I am getting myself in a twist trying to use the if function here.

Thank you

Herbert

[swuehl]

Maybe like

=Sum({<Year = {2014}>} Aggr(FirstSortedValue({<Year = {2014}>} [Loan($)],-Date),[Grower No.]))