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

    Set analysis with Max function

    Andrea Gigliotti

      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