16 Replies Latest reply: Dec 18, 2015 1:47 AM by Aswin raaj RSS

    RE:Rows to column

    Chanty 4u

      hi all...

       

      i hve data with rows like'

       

      Revenue bucketForecsatRevRegionCustomerCommentsRevTermsPeriodWeek

             

      firm123aAxxfabcd15_Q433
      qtdsles122bBgdsgabcd13_Q334
      risk_h34cCfffdsff11_Q335
      risk_l55dDgggd10_Q433
      ups_h66sEgghf11_Q334
      ups_l78eFgsfhh15_Q335
      firm123aAxxfabcd15_Q433
      qtdsles122bBgdsgabcd13_Q334
      risk_h34cCfffdsff11_Q335
      risk_l55dDgggd10_Q433
      ups_h66sEgghf11_Q334
      ups_l78eFgsfhh15_Q335

       

      i hve data above ...but i want   oonly  WEEK row as

      Revenue bucketForecsatRevRegionCustomerCommentsRevTermsPeriod

      33  34 35

       

      and Revenue bucket is my measure...? i want that values in week column  like pivot table

       

      how can i achieve dis in pivot table?