Aggregated sum by max date

[Anonymous]

Good day!

I have some source:

Id	Date	Sales
1	15.02.2016	45
1	16.02.2016	654
2	15.02.2016	54
2	16.02.2016	1
3	15.02.2016	45

I expression i need to calculate Sales by Id. if some Id has more then one Date, expression must get max date.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

Try FirstSortedValue(Sales, -Date)

[sunny_talwar]

Implementation of Gysbert's suggestion:

[Anonymous]

Thanks!

[Anonymous]

Thank you!

Can i use filters inside this expr?

[sunny_talwar]

You sure can

[jolivares]

The expression is:

FirstSortedValue(Sales, -Aggr(Max(Date(Date#(Date,'DD.MM.YYYY'))),Id,Date ))

But you have to take care of your field "Date", is better if you put in the correct format.

[sunny_talwar]

You can add set analysis to FirstSortedValue function:

FirstSortedValue({<Field = {'Something'}>} Sales, -Date)