6 Replies Latest reply: Feb 9, 2017 2:17 AM by Gowthamatnaik Basangi RSS

    Calculation problem in Counts

    Siva Prakash Thummalapenta

      Hi Buddies,

       

      Can u please help me out to calculate the count in straight table

       

      For example:

      if i do sum(total field) i'm getting total sum but i'm expecting sum by year wise. please help me out. Thanks in advance.

           

      FiscalYearService Type            Field    count(total field)  Expectaion
      FY13Type31323938
      FY13Type42523938
      FY14Type32923971
      FY14Type44223971
      FY15Type11239130
      FY15Type25239130
      FY15Type368239130
      FY15Type456239130