Percentage Column in Crosstab

[Ells]

I am building P&L reports in a crosstab.

                   Actual      %
Sales A           75
Sales B           25
Total Sales     100

Materials         30
Labour            25
Services          10
Total Costs      65

What I need is a calculation to derive each revenue/ cost line as a % of Total Sales.

E.g. Materials would show as 30% (30/100).

I have tried unsuccessfully to insert a calculation to do this.  I would appreciate any help on which function I should try next.

Thanks

[technol]

try this ,into your pane tools, select a query calculation and draft until your work area and write your calculation.

revenue= (amount * 30) /100   it's all.