Like I already explained in my opening post, the only fields you can sort by with right-click are fields that exist in the datasource itself. If it is a calculated field, it is not listed in the drop down menu for fields in sort menu.
"$ Per Day" does NOT exist in the datasource. It is a calculated field from two different datasources: datasource1.sum(net_amt) / datasource2.sum(days spent)
datasource1 is a database.
datasource2 is an excel sheet.
I am not allowed to modify either one.
well if you post you book I'll look at it