3 Replies Latest reply on Jun 18, 2018 9:11 AM by Lisa Keating

    Sort by Dimension

    Lisa Keating

      I have a spreadsheet of student applications by nation for 5 Fall Terms (Fall 2018, Fall 2017, Fall 2016, Fall 2015, Fall 2014).  I would like to sort descending by the number applications for each nation but not by Grand Total.  I would like to show the nation with the highest count of apps in Fall 2018 at the top (then Fall 2017, then Fall 2016 and so on if possible).  For clarity, I've pasted two screenshots below.  I would like the order to be India, Nigeria, Nepal, Canada ... not India, Nigeria, China, Mexico.  Help?  I only write a bit of SQL, so I would appreciate step-by-step instructions.  Thank you.