5 Replies Latest reply on Mar 30, 2018 2:28 PM by Venu Gopal Vegi

    Add an extra column for year total

    Venu Gopal Vegi

      Hello Everyone,

       

      I need small help here

       

      i have a months listed like this:

       

      Header 1JanFeb
      Mar
      AprJunjulaug
      sep
      oct
      novdec
      ats year total
      Dept 1

      Dept 1

      Dept 1
      Dept 1
      Dept 1
      Dept 1

       

      but i need my data like this:

       

      Basically i want year total be sum of months , ats year total is a different entity that we need to compare with

      this is the Dimension:

      Month: Jan, Feb,......, Dec, ATS Year Total

       

      Header 1JanFeb
      Mar
      AprJunjulaug
      sep
      oct
      novdec
      year total
      Ats year total
      Dept 1

      Dept 1

      Dept 1
      Dept 1
      Dept 1
      Dept 1

       

      Thanks in advance