Row as % of total Value

[#1]

I try to create a formula to show each row as % of the total value i.e. 45%, could you help please?

thanks

type	Value	as% of total stock
AA	£1,979,308	45%
BB	£1,214,064	28%
CC	£433,028	10%
DD	£386,512	9%
EE	£368,596	8%
£4,381,508

[trdandamudi]

May be like this:

Expression:

=Sum(Value) / Sum(Total Value)

[awhitfield]

Hi Maria,

see he attached worked example

[#4]

=sum(Value)/sum({1}Total Value)