3 Replies Latest reply: Nov 23, 2013 9:58 AM by Bill Markham RSS

    Repeating  the  values  in a straight table/Pivot table

      Hi guys

       

      I have a straight table as :

       

      Product_CodeCalendarMonthStandardCostQ
      5002041Jan194567.7793
      Feb0108
      Mar0114
      Apr092
      May052
      Jun056
      Jul092
      Aug0107
      Sep96240.1569
      Oct0147
      Nov090
      Dec0136

       

       

       

      I want the output as :

       

      Product_CodeCalendarMonthStandardCostQ
      5002041Jan194567.7793
      Feb194567.77108
      Mar194567.77114
      Apr194567.7792
      May194567.7752
      Jun194567.7756
      Jul194567.7792
      Aug194567.77107
      Sep96240.1569
      Oct96240.15147
      Nov96240.1590
      Dec96240.15136