Calculated Column

[#1]

Hi All,

I have a problem. I need to create calculated column that will show % which will be calculated by Number/ Total.

Example:

A	95	26%
B	94	26%
C	46	13%
D	29	8%
E	100	27%
Total	364	100%

A 95 =(95/364)=26%.

Please help on this.

[varshavig12]

sum(Sales)/sum(Total Sales)

[khalander]

=sum(Sales)/Sum(TOTAL(Sales))

[Anonymous · Accepted solution]

Hi Narendra,

Use this expression:

=sum(Sales)/sum(TOTAL(Sales))

[#5]

Thank you very much both of you