10 Replies Latest reply on Mar 24, 2016 10:26 AM by Vengatesh

    sorting on measure column in a pivot table

    Vengatesh

      Hi All,

       

      I need to sort a pivot table based on a measure column.

       

         

      Measure ValuesGrand Total
      rank 3/113/12 3/13
      212102244
      110201040
      315102550

      I already tried below mentioned approach, but it is not working.

      1) Make a duplicate layer of themeasure column.

      2) Move the duplicate layer to the far left in the Rows section.

      3) Apply the desired sort order.

      4) Hide the duplicate layer column.

       

      I need to sort the rank column in ascending order.

      Can some one please let me know if there is any other approach to resolve this.

       

      Thanks,

      Vengatesh.