3 Replies Latest reply: May 14, 2014 10:34 AM by K K RSS

    Pivote Sort


      Hi All,

       

      Can any one help on the below issue.

       

      I have a pivot table shown below

      BEFORE
      PHYSICANVALUE
      OTHERS476
      FETES56
      CROTZER76
      GERSHMAN99
      JOSEPH123
      BAXTER34
      JOHN56
      TOTAL920

       

      Now I want the "OTHERS" category to be shown at the bottom (Shown below)

       

      AFTER
      PHYSICANVALUE
      FETES56
      CROTZER76
      GERSHMAN99
      JOSEPH123
      BAXTER34
      JOHN34

      OTHERS

      476

      TOTAL920

       

      Note: I dont want to use the sort values by Accending here. Only the Other should be shown below and the rest should remain the same.

       

      Thanks in advance.

       

      Regards,

      KK