Sales Data for max Date

[turodionova]

Hi!

I need to create report with sales data by customers related to the latest sales date for each.

Yellow lines in the table below are what i need to extract.

I use an expression: aggr(max(Date),[Customer]) and get right date for every Customer.

Then i try to use this expression for sales data: sum({$<Date={"=aggr(max(Date),[Customer])"}>}Sales) 

and get a wrong result.

Thanks in advance.

[maxgro]

try with

SubField( concat( Sales, '@', -Date), '@', 1)