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.