1 Reply Latest reply: Mar 8, 2012 12:51 PM by Ashok Chandran RSS

    how to sort in pivot tables on groups and subgroups

    vikas mahajan

      Dear All,

       

      How to sort in pivot tables on groups and subgroups on numeric values as well as on a-z  alphabetic order.

       

      Thanks

       

      Vikas Mahajan

        • how to sort in pivot tables on groups and subgroups
          Ashok Chandran

          Hi

           

          Using the sort expression you can sort your pivot table.

           

          In the sort expression you can specify your sort order like numeric , text.

           

          If you want to sort some specific manner means you can create the sort order variable for that particular field.

           

           

          like Country  SortOrder

           

          A           1

          B           2

          C           3

          You can mention this order in inline in script

           

          Then you can use this sortOrder in sort exprssion

           

           

           

          Regards