we have more or less the same issue. The lowest level is the profit center level and above we have two/three higher levels, where profit centers are summarized. The highest level is in the end the whole company.
Means we would do the same steps like you have described above to calculate a new KPI (in this case Net Loss Ratio).
On the lowest level (profit center level) the results are fine (each profit center has the value which is shown in the table) but as soon as we choose the next level (for example sum of 10 profit centers) the calculation for this measure is not working.
Can you help us here to fix this issue? I guess the issue is that in our hierarchy we have several levels.