Monday, September 17, 2012

Sorting a matrix by aggregate

  • right click on the top right corner of the matrix and go to matrix properties.
  • select the groups tab.
  • select the group1 row, click edit.
  • click the sorting tab.
  • enter your totalling expression, and decide if you want it to sort in ascending or descending totals order.