Normally data table can sort order by one column, just have left table shows, sort by column "Name".
but how to use JMP to sort by two column? order by both "Name" & 'Date", like the right table shows, kindly help to suggest.
thanks a lot.
Name | Date | Accomplish amounts of work | --> | Name | Date | Accomplish amounts of work |
John | 20/8/21 9:03:59 | 100% | Kevin | 20/8/17 9:03:57 | 60% |
Kevin | 20/8/22 9:03:59 | 80% | Kevin | 20/8/18 9:03:57 | 40% |
Kevin | 20/8/23 9:03:60 | 77% | Kevin | 20/8/19 9:03:58 | 50% |
John | 20/8/20 9:03:58 | 67% | Kevin | 20/8/20 9:03:58 | 33% |
Kevin | 20/8/17 9:03:57 | 60% | Kevin | 20/8/21 9:03:59 | 0% |
John | 20/8/18 9:03:57 | 60% | Kevin | 20/8/22 9:03:59 | 80% |
Kevin | 20/8/19 9:03:58 | 50% | Kevin | 20/8/23 9:03:60 | 77% |
John | 20/8/19 9:03:58 | 50% | John | 20/8/17 9:03:57 | 40% |
Kevin | 20/8/18 9:03:57 | 40% | John | 20/8/18 9:03:57 | 60% |
John | 20/8/17 9:03:57 | 40% | John | 20/8/19 9:03:58 | 50% |
Kevin | 20/8/20 9:03:58 | 33% | John | 20/8/20 9:03:58 | 67% |
John | 20/8/23 9:03:60 | 23% | John | 20/8/21 9:03:59 | 100% |
John | 20/8/22 9:03:59 | 20% | John | 20/8/22 9:03:59 | 20% |
Kevin | 20/8/21 9:03:59 | 0% | John | 20/8/23 9:03:60 | 23% |