If you want the Top 10 Items per month then a Ranking function (RANK(), ROW_NUMBER()) is going to be the best way to move.
However without sample DDL and Input data as well as out put data its difficult to advise on the best solution.
_________________________________________________________________________
SSC Guide to Posting and Best Practices