Calculate % of Total

[pwomack]

Using Actuate e.Spreadsheet Designer 8 Service Pack 1.

I have a pivot table that displays as such:

[u]Product Status Count[/u]
hammer  new     10
        used    15
        lost    20
hammer total    45

wrench  new      5
        used    10
        lost    20
wrench total    35

I want to show a % of total for each status for each product, such as:

[u]Product Status Count % Total[/u]
hammer   new    10    [COLOR=red]22.22[/color red]
         used   15    [COLOR=red]33.33[/color red]
         lost   20    [COLOR=red]44.44[/color red]
hammer total 45

wrench   new     5    [COLOR=red]14.28[/color red]
         used   10    [COLOR=red]28.57[/color red]
         lost   20    [COLOR=red]57.14[/color red]
wrench total 35

Can someone tell me what steps I need to do to get the % of total?