5 Replies Latest reply on Mar 10, 2016 10:14 PM by Tharashasank Davuluru

    Calculate fields for Current month Sum(amount), YTD Sum(Amount)

    Shanaka Gunaratna

      Hi All

       

      I have a data set as follows

      Period, Group, ServiceLine, SubServiceLine, Amount

      '2016-01', A, AA1, AAA1, 1000.00

      '2016-01', A1, AA2, AAA1, 1000.00

      '2016-02', A3, AA3, AAA1, 1000.00

      '2016-02', A4, AA4, AAA1, 1000.00

      '2016-03', A5, AA5, AAA1, 1000.00

      '2016-03', A, AA5, AAA1, 1000.00

       

      I want to create a report to display  Group, ServiceLine, SubServiceLine,  Amount - CurrentMonth, Amount - YearToDate

       

      How to create 2 calculated fields:  Amount(CurrentMonth), Amount(YearTodate)

       

      Thanks