Column with percentage of row total

Column with percentage of row total

Hi,


I have data like this in a matrix, which I have no problem doing based on the quantities from my data source:


Green#

Yellow#

Blue#

Total#

Europe

5

3

8

16

Asia

7

9

7

23



What I need is to add a column where the values are a percentage of the row totals, calculated on basis of the quantities I already have - like this:




Green#

Green%

Yellow#

Yellow%

Blue#

Blue%

Total#

Total%

Europe

5

31%

3

19%

8

50%

16

100%

Asia

7

30%

9

39%

7

30%

23

100%

Any input on how to do this?

Thanks,
Anders