5 Replies Latest reply: Apr 25, 2013 3:28 PM by Anders Moller RSS

    setanalysis sum calculation fo selected date

    Srinivasa D
      Hi
      I have 2 set of date one is  sondate and other is Actualdate as like below
      Header 1Header 2Header 3Header 4
      ProductAsondateActualdateAmt
      A2/26/20111/31/2011100
      A2/26/20112/16/2012200
      B3/31/20131/31/20131500
      B3/31/20132/28/2013100
      B3/31/2013

       

      3/31/2013

      200

       

       

      If I select As on Date 2/26/2011 then need to
      calclulate  sum of Actual date (1/31/2011+2/16/2012) it should be 300  can any suggest how I can
      achive this in setanalysis

       

       

       

       

       

      Thanks