3 Replies Latest reply: Feb 22, 2013 12:45 PM by Gysbert Wassenaar RSS

    Total on Averaged value

    Lalmohan Behera

      Hi

      I have data on this format

      YearQuarterMonthAmount
      2013Q11100
      2013Q12120
      2013Q2490
      2013Q25140
      2013Q37110
      2013Q38100
      2013Q41180
      2013Q41290

       

      I wanted tocreate result as

      YearQuarterQuarter AverageYear Total
      2013Q1110415
      2013Q2115415
      2013Q3105415
      2013Q485415

       

      Thanks,