1 Reply Latest reply: Jul 7, 2016 5:55 AM by Sunny Talwar RSS

    how to perform above in pivot table

    anusha vemuri

      Hi  all

      swuehl 

      how to we get above functionality in pivot table

       

      for eg:my sample data

       

      datechipab
      1c1100700
      2c1200800
      3c1300900
      4c14001000
      5c15001100
      6c16001200

       

       

      I want column d such that d1=a+b=800 for date 1

      for date2=date1 bal+b(of date2) -a(date1)

       

      output

      chip123
      c1a100200300
      c1b700800900
      c1bal800800+800-200=14001400+900-300=2000