6 Replies Latest reply: Oct 4, 2012 8:38 AM by Gysbert Wassenaar RSS

    Ignoring dimension in a straight table

      Hi guys,

       

      I have data in the following form and would like to create a straight table which has the same fields (Code, Date and balance) but the balance field should have accumulated values (chronologically) .

       

       

       

      CodeDateBalance



      R172031-Aug-1220,971
      R172003-Sep-1212,994
      R172004-Sep-12-12,807
      R172005-Sep-121,366
      R172006-Sep-12-15,303
      R172010-Sep-122,931
      R172018-Sep-12-12,269
      R172028-Sep-126,380
      R172001-Oct-1247
      R172004-Oct-121,701

       

       

       

      The straight table should look something like this. Please note the last row sums all the values because the date field is the highest.

       

      CodeDateBalance
      R172031-Aug-1220,971
      R172003-Sep-1233,965
      R172004-Sep-1221,158
      R172005-Sep-1222,524
      R172006-Sep-127,221
      R172010-Sep-1210,152
      R172018-Sep-12-2,117
      R172028-Sep-124,263
      R172001-Oct-124,310
      R172004-Oct-126,011

       

       

      Would appreciate all the help i can get

       

       

      Regards

       

      Faisal