Hello. I have a formula that I have developed to rank some employees at my company, but that formula includes a couple of running totals.
I would like to sort that formula by highest to lowest - however, because there are running totals involved, it does not allow me to do any sorting on it.
Does anyone have any suggestions on how I could sort on a formula that includes a running total? Unfortunately because of the design of the report, I have to utilize running totals and not summary fields.
Any suggestions would be appreciated. Thanks