Is it possible to get a report that shows me percentages?

For example;

I would like see how much percent a sub category is of all my tickets is for this year.

so  

sub category 1.1 = 10% (of all tickets)

sub category 1.2 = 5% (of all tickets)

sub category 1.3 = 3% (of all tickets)

sub category 2.1 = 50% (of all tickets)

sub category 2.2 = 30% (of all tickets)

sub category 2.3 = 2% (of all tickets)

Best regards,

Allistair

Edit:

I am running SCP 7607 and MS SQL server