21 Replies Latest reply: Feb 4, 2016 3:51 AM by Andrea Gigliotti RSS

    Set analysis with Max function

    Andrea Gigliotti


      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