2 Replies Latest reply: Nov 23, 2016 11:55 AM by Silvia Ganhao RSS

    Get Max Date Ignoring dimension

    Silvia Ganhao



      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.




      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,