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




      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