2 Replies Latest reply: Nov 23, 2016 11:55 AM by S�lvia Ganh�o RSS

    Get Max Date Ignoring dimension

    S�lvia Ganh�o

      Hi,

       

      I've attached an app, I really could use your help.

       

      In that app, I have a table with StoreCode | ProductCode | MaxDate | SumQuantity.

       

      I want to get the MaxDate for StoreCode regardless ProductCode.

       

      Example:

       

      when I have StoreCode = 2383 I want  MaxDate = 2016-06-01 in every occurrence of StoreCode = 2383.

       

      And in SumQuantity I whant the value of sum Quantity in that date.

       

      Can you please help ?

       

      Thanks in advance,

      Sílvia