how to get column level percentage

[#1]

Hi All,

My Data Looks like

A     B     C       D      Total  %a            %b            %c     %d

10  20      30     40      100    =10/100   =20/100  =30/100  =40/100

Could you help how to get the precntage part

[MindaugasBacius]

In expression use:

=Column(1)/Column(5)

=Column(2)/Column(5)

and move on.

In Number sheet set:

[sunny_talwar]

You can try like this:

A/RangeSum(A, B, C, D)

B/RangeSum(A, B, C, D)

C/RangeSum(A, B, C, D)

D/RangeSum(A, B, C, D)