6 Replies Latest reply: Feb 18, 2013 9:36 AM by Michael Ionkin RSS

    Sorting via formula problem

    Michael Ionkin

      dear all

       

      Sorting.jpg

       

      I try and try to get it work, but unfortunatly I have little success.

      I have a date and a number as a joined dimension. I want the dimension to be sorted like this:

      12.07.2012_3

      12.07.2012_1

      12.07.2012_2

      13.07.2012_3

      13.07.2012_1

      13.07.2012_2

       

      Im using a formula to sort the date (the result of it you can see above(Figure)) :

       

       

      if(Schicht = 3, CalDate&1,if(Schicht = 1,CalDate&2,if(Schicht = 2,CalDate&3)))

       

      Any ideas ??