3 Replies Latest reply: May 23, 2012 3:28 AM by Sunil Chauhan RSS

    Display Differences by Period

      I have a table with 3 fileds Customer Name, Period(Date), Balances

       

      Sample

       

      Customer Name Period  Balance

      A, 01-May, 100

      A,02-May, 200

       

       

      I would like to display this in a Straight Table/ Pivot Table as follows

       

      Customer Name Balance(01-May) Balance (02-May) Diff

      A, 100, 200, 100

       

      Appreciate support