I am working on a requirement where we have calculated some values of Prod/QA/Training in different steps. We have to calculate Overall Average by adding all the values of QA and Prod .
For example in the given example 5+7+2+1+4=19

I am able to achieve this using windows function but we need this in KPI chart which is throwing Table calculation error which I use the same formula.