7 Replies Latest reply: Jul 11, 2013 4:34 AM by Mark Sheraton RSS

    aggrgate below fields

    Raj Vadde

      Hi ,

       

      I'm trying to get YTD in reverse order

       

      here are my monthly values

       

      sep - 200    

      oct - 210

      nov - 300

      dec- 400

      jan - 100

      feb - 200

      mar- 230

       

       

      and expected output should be

       

      sep  - 1540

      oct - 1340

      nov - 1130

      dec- 830

       

      etc

       

       

      how to write the script logic for thislogic in script () and  not in the front end chart calculation

       

      i also need to do group by with certain filter fields

       

      Any suggestions