3 Replies Latest reply: Jul 8, 2015 2:52 AM by sindhu kannan RSS

    How to sort by expression - to sort biggest value to smallest value

    Jim Chan

      HI there,

       

      i have created a PIVOT table, in my total value, it cant seems to be sort by biggest value to the smallest. So i guess have to use sort by expression? If thats so, how should i write it ?

       

      example, my total value - 2000, 5000, 3000, 1000, 4000. but i want it to be 5000, 4000, 3000, 2000, 1000.

       

      Rgds,

       

      Jim Chan