Create income statement table with common size

[katetsan]

Hi,

I want to create a income statement table with common size%, and  my raw data format is as below.

Can I create an income statement table with common size% as below table2?

Thanks a lot!

<Table1> Raw data format

Item	Revenues	Costs	Expense
A	100	20	10
B	110	22	8
C	90	25	9

<Table2> Income statement table with common size%

Item	Total Number	%
Revenues	300	100%
Costs	67	22.3%
Gross	233	77.7%
Expense	27	9%
Profit	206	68.7%

[devarasu07]

Hi,

Duplicate thread & help to close this, replied in your another post with same question.

Create income statement table with common size percentage