Adjusting formulas to be generic

[Anonymous]

Hello,

please find attached this table.

I have an issue please help to check.

In the table i want to calculate the cumul sales and i noticed it works by using this formula

RangeSum(Above(TOTAL ([Actual Sales]), 0, RowNo(TOTAL))) but if i want to see many sub zones  more than two let's say 10 sub zones the formula does not work correctly.

So can you adjust the formula in order to get correct values even i wawnt to see many sub zones at the same time?

Just another note the formula works correctly with many sub zones for only january and february and then it works incorrectly.

Thank you for helping me.

Alâa Eddine.

[sunny_talwar]

Look here

Adjusting formula to be generic