the last date

[sebastianolivar]

Hello Comunity,

I am Sebastián. I have a little problem whit a expresion.

for example:

I have the sales of each stores with yours date of sales.

I need a expression to get the last sale (according the date) to each Store. 

I tried with sum( {< Date sale= {"$(=date(max(Date sale)))"} >} Sales  , but its not working. 

[Vegar]

Try
Sum(
If( [Date sale]= max([Date sale]),Sales,0)
)

[Anonymous]

sum(if([Date Sale] = aggr(Max([Date Sale]),Customer,Store),Sales))