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
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.