Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
May be like this:
Expression:
=Sum(Value) / Sum(Total Value)
Hi Maria,
see he attached worked example
=sum(Value)/sum({1}Total Value)