Analytics Software

I need to create a report to look like this. Everything has been done except the %A and %B columns. That still needs to be created. However i am creating these 2 columns by hand, so you can see what i have in mind and how i need the calculation to work.


Race General | Race | Total | Category A | % A | Category B | %B
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
African | African Male | 1000 | 600 | 12% | 400 | 8%
African | African Female 1500 500 | 10% | 1000 | 20%

Subtotal African 2500 | 1100 | | 1400

Indian | Indian Male | 2000 | 1000 | 20% | 1000 | 20%
Indian | Indian Female | 500 100 | 2% | 400 | 8%

Subtotal Indian 2500 | 1100 | | 1400

Grand Total 5000 | 1200 | | 2800


Now the calculations are done as follow:
1. Grant total was done using Tools > Totals > Sum of all data points
2. Total was calculated inside select statement Total = category A + category B
3. Subtotals were done using Tools > Totals > Sum of all data points > Subtotal at each change in Race General

My question is: how do i calculate %A ? How do u do it in desktop as there is no option to select Grant Total of 5000 anywhere. Keep in mind i need to base my caluculation on the Grant Total (5000) amount that was created using tools > totals > sum of all data points. That grant total will change when different dates are entered. So it cannot be hard coded. I need something along the lines of Category A / Grant total 100*

ps....the current 12%, 10%, 20%, 2% etc was created using a calculator to demonstrate my need. So currently there is no values inside %A column. There is not even such a column. it all has to be created