How can I identify worst performers in Financial Reporting Studio?
I need to identify my best five and worst five employees in a FR report. Best ones are no problem - I just select Top 5 based on a value in the selected colum and it gives me five rows with names and the largest numbers. I don't have "Bottom" 5 - at least not in 9.3.3. I tried to do the following: multiply the column with data by negative 1, as the smallest positive number will become the largest negative, and get top 5 based on the negative numbers. It just didn't do anything and returned the whole list. Any ideas how
0