Problem with Above Function. Resets when the dimension changes

[#1]

Hi everybody, I have a problem with the function Above. I've made a Single Table to check the balance of my Bank Account and the balance in my ERP. I have to dimensions: YEAR and MONTH. The problem is in the expression "Balance NAV" which has this formula:

"Amount NAV" + IF(ISNULL(Above ("Balance NAV")),0,Above ("Balance NAV"))

With this formula I try to have an "acumulated balance", but when the year change (and so the RowNo reset and begins again with 1) the formula does not work. Because the value of Balance NAV in Ene (January ) /2010 should be 93907.05 + 5640.42 = 99547.47.

Does anybody know how to avoid this "reset"?

Thanks a lot.

[pover · Accepted solution]

Pedro,

Try using the Total modifier:

above(total Balance.Nav)

Regards.

[#3]

That`s it. Thank you!!!