what is the percentage formula in COPA two axis form report

146 Views

Hi Experts,

What is the formula to get Percentages against to column in COPA two axes Form Report?

Ex: In below Report format layout: I want to see Material & other components cost percentage on Sales in 3rd column.

Known formula is =

In Costing formula is = (Material cost / Sales)*100

i.e., = (350/1000)*100=35%, [in excel (B3/B$1)*100] I couldn’t able to get the % values in 3^rd column.

Lead Column Actual Per % Sales 1000 Material 350 ? Machinery 80 ? Labor 120 ? Other OH 200 ? 750 Profit 250

So could you please help what is the correct formula and where can I get other similar kind of formulas?

Thanks in advance for your immediate assistance.

Regards,

Shiva T