how to do a statistics on top 10 diagnosis for org?


I still wonder how to design a model to evaluate org’s top 10 icd-10 diagnosis, by aggressive way? but the top 10 diagnosis for a month,six-month,year is different. by track way, many icd-10’s diagnosis sum or list cause system crash . just filter the common diagnosis is a compromise, but the event report table has no order function…

what’s the best way?