2 Replies Latest reply on Dec 21, 2012 1:29 PM by siddhartha.siddhartha

    Getting the latest measure value according to latest date.

    siddhartha.siddhartha
      Hi
      I have this below probem to solve, the data given below has 1deal id which has multiple product id's. So now what i want is that if the user selects any "trans date" he should have the sum of the "exposure" for all the product id's under that dealid .
      To explain
      1) user selects 18 june then sum of exposure should be 17500 + 10500 + 70000
      2) user selects 7 july then sum of exposure shoud be 12600( latest for productid =1) + 10500 +7000.
      deal idproduct idtrans dateexposure
      2049999516/17/2011  12:00:00 AM17500
      2049999517/6/2011  7:47:40 PM12600
      2049999526/17/2011  12:00:00 AM10500
      2049999536/17/2011  12:00:00 AM70000
      2049999527/26/2011  10:01:02 AM0
      2049999537/26/2011  10:01:02 AM0
      2049999517/27/2011  10:20:13 AM25200
      2049999517/27/2011  10:24:53 AM0
      Please help me in to get the solution.