Preserve Formulae - Smart View

Hi Wizards,

I could see formulae is not preserved when I perform zoom in and here are the details:

Row B3 - 10 (Parent), Child 01

Row B4 - 20 (Parent), Child 02

Row B5 - = SUM(B3:B4)

I perform zoom in @ B3, which will fetch the child 01 (B3); 10 (B4), 20 (B5) and the formulae moves to B6 as = sum(B4:B5)

I perform zoom in @ B5, which will fetch the child 02 (B5); 20 (B6)  and now the formulae moves to B7 as = sum(B4:B7) à Here the formulae is including the child of 20 and the sum function goes on a toss.

In the member options, ‘Preserve Formulas and Comments in adhoc operations (except pivot) is checked. But still, the formulae’s are not preserved.