Percent of a total in crosstab for 3 different data items not calculating

[mixels]

Hi -

I am trying to calculate % of a total by year, by region, by salesrep of a total for the particular year. My report looks like the example below but I am not getting correct % of total calculated.

Year   Region   Salesrep   Sales   % of total
2012   Americas   Peter   1000   13%
2012   Europe   Jack   2500   33%
2012   Asia   Cornel   4000   53%
Total 2012      7500   100%
2013   Americas   Peter   3400   33%
2013   Europe   Jack   4500   44%
2013   Asia   Cornel   2300   23%
Total 2013      10200   100%


I tried using percent([Sales] for [year]) but didn't work. I also tried using percent([Sales] at [Salesrep], for [year]) and still didn't get the right percent. Not sure how to get the % caclulated correctly.

Any help would be appreciated.

Thank you!

[mixels]

Solved my own issue. Thanks!  :)