2 Replies Latest reply on Sep 8, 2016 11:29 AM by Rahul Upadhye

    How to transpose selected rows (measure values) to column?

    Kelly Wu

      Hello all,

       

      I am trying to create a table where selected columns need to be transpose to rows and some stay in column format. Here are the measure values I have.

      Accepted #Rejected #Pending #Accepted AmountRejected AmountPending Amount
      123

      12

      14$100$20$10

      I would like to have a result table looks like:

      #Amount
      Accepted123$100
      Rejected12$20
      Pending14$10

       

      I was able to swap the "#"s to rows first then create a calculated column name # with conditions "". Could anyone give me suggestions on how to swap the amount part? I greatly appreciate your help.