2 Replies Latest reply: Jan 29, 2018 1:39 AM by Haidar Haj Ali RSS

    Sort by expression

    yusuuf rawat

      I have a pivot table with two dimensions Region and Department and two expressions Sum(Actual) and Sum(Budget)

      For the region i have them sorted by expression as region 1 , 2 , 3, admin ect

       

      Now how do i sort the department within each region . I want to sort them by the smallest difference between expression 1 and two first

                                             actual  budget

      eg region  1  depart10  100 99

                            depart 8    50 84

                            depart 3    2    100

         region 2       depart 5   80 100

                              depart 2  10  90

       

      so the department with smallest difference between actual and budget must be first for each region .

       

      Please assist