1 Reply Latest reply: Sep 7, 2016 5:10 AM by Gysbert Wassenaar RSS

    Calculating Absolute and Net values

    Deepak Sharma

      Hi

       

      I have a requirement where I have to calculate the sum of absolute and net values

      Please refer below data sets for your refrance.

       

      YearMonthBalance
      2010Jan100
      2010Feb-100
      2010Mar200
      2011Jan300
      2011Feb-100
      2011Mar-500
      2011Apr300
      2012Jan-100
      2012Feb100

       

      Can some one help me in achiving the functionality using Pivot table.