How to calculate the percentage of values in two rows in a chart

[Anonymous]

Hi

I have a chart look like this (chart 1). I want to add a row for % Var which equals to Var/Est. The final chart should like chart 2. Any idea how to do that?

chart 1

Chart 2

Thanks

Zixiao

[maxgro · Accepted solution]

PFA

[Anonymous]

Thanks:)

[jsakalis]

See attached. A slightly different version that calculates variance on the fly and displays differently.

Thanks Massimo for reminding me of Dimensionality() - I think that may be a better choice.