Ranking Using Grand Total
 

I have data by months and when I use the ranking function, it only allows me
to use one month, i.e. Jan, Feb, or Mar.... I would like to rank the data
using the grand total of each row. Is that possible? The option in the
ranking does not give me the grand total column and I want to compare data
over a course of time. I think if I choose one month then it will only give
me the ranking information for that month and it could vary over the course
of the year. Am I wrong?

Thank you inadvance for your help!!