To sort on multiple columns, select each column in turn and click either Ascending or Descending. Columns will be sorted in the order entered. Dimension columns can be sorted Numerically, Alphanumerically or Case Sensitive Alphanumerically.
Analytics Edge will transparently make multiple queries to get all your results. You can limit the query by entering a number other than zero.