Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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