Can you sort reports based on multiple columns?

You should be able to do this by either clicking the column header to toggle the sort on those columns or by clicking the group by column.

If you want to sort by multiple columns, you need to hold down the shift key while you select the columns you are sorting by. Note - the order you shift click these columns in is the order that they sort in.

Lorin,

Thanks for the 'hold shift' tip. I didn't know that was a possibility.

I'm still getting unexpected sorting. Notice below how the sub-division is sorted odd. When I use just the sub-division code it sorts fine, but I would like to have the sub-division titles as well.

Thanks for reporting. I'll have the dev team take a look at the sorting to see what's going on.

This is fixed locally and should go out with our next update. 🙂