my table format is in this form ::
empname salary merit
abc 1000 good
def 2000 good
hjg 3000 good
xyz 0 bad
Now i want to display in this format
good maximum(in percentage)
bad maximum(in percentage)
these 3 values must be calculated considering all the employees.
That means how many maximum persons have good merit, minimum persons having good merit,average persons having good merit...
Similarly with bad merit...
It must be in a genric way such that in future i may increase merit type i wnt be only for good and bad.... Hope all understood my problem...
Help is greately appreciated.Thanks in advance