Set analysis with Max function

[agigliotti]

Hello,

I'm stuck with the below expression:

Sum( {< Field1={"SALES"}, Field2={"EEEE"} >} if( DeliveryDate = Max(DeliveryDate), Quantity, 0 ) )

using the following dimensions: customer, delivery number, delivery date

I need to SUM only the items sold in the last delivery for each customer.

How can I achieve it ?

Please help me.

Best Regards

Andrea

[elyM]

Hi Andrea,

I have tested this expression on your qvw

RangeSum(If([%Data] = Max({$< %TipoVenditaLink={"VENDITA"}, DirettoGrossista={"Diretto"}, CategoriaArticoloID={"122"}, Vendite.Tipo.Documento -= {"RESI"} >} TOTAL<Cliente> %Data),sum(Qta),0))

Regards,

Ely

[agigliotti]

Hi Ely,

I'll let you know asap if your suggested expression give me the right result.

Many thanks for your collaboration.

Best Regards

Andrea