6 Replies Latest reply: May 30, 2015 2:23 PM by Briana Diaz RSS

    Pivot Table Dimensions to Expression

    Settu Periyasamy

      Hi Team,

      Find the below screen shot.

       

      QV_Help.JPG

       

      Source Data
      CtypeFromToProductRateRec_No
      NETP5/31/200812/31/2015BRND297076.851234
      NETP5/31/200812/31/2015BRND297076.851235

       

      In the Source data, Ctype, from, to , product and rate fields having same data. but the Rec_No is different. I need to make the single row for the product, Rate and Rec_No should be in the row field(Pivot table).

       

      Thanks