I have a table with Business services down the X axis and Business units across the Y axis as headers. how can I change the order that the business unit (or really any header in any table) appears? I'd like the columns to be sorted left to right in either alpha or descending order.

You can click and drag each column header left or right to a new position in the report table.

Here's an example of alphabetically sorted business unit column headers.

BEFORE

AFTER

To produce the table above, I also froze the position of the Service Name column.

(right-click column header name > Freeze Column)

Manual positioning is the only option for table column order.

Table row order on the other hand can be set for ascending or descending for each field listed in the Rows section of your ad hoc query configuration dialog: