6 Replies Latest reply: Jun 13, 2011 5:21 AM by Erika Jain RSS

    Using both "Group By" and "Order By"

      Using a table like the following:

       

      LOAD FirstValue(name) INLINE [
          id, type, name, age
          1, man, dave, 65
          2, man, chris, 66
          3, woman, mary, 64
          4, girl, karen, 27
          5, woman, betty, 60
          6, boy, john, 22
          7, man, peter, 40
          8, boy, jay, 21
          9, girl, sandra, 20
          10, man, bob, 23
      ] Group by type Order by age;
      

       

      To get a listbox like this:

       

      • bob
      • betty
      • sandra
      • jay

       

      But the script dont allow me to use Group By and Order By at the same time, any ideas?

       

      best regards.