Use BEFORE in PivotTable

[#1]

Hi

I have difficulty withthe task of calculating the cumulative total in a PivotTable.

I use formula: "RangeSum(Before( total sum(TestValue),0,9999))" but it does not work if in PivotTable explanded different dimensions.

example in attachment

[vijay_iitkgp]

hi,

use above instead of before

[#3]

Hello

I checked this operation of portrate-report with above function. it does not work too (if in PivotTable explanded different dimensions)

new example in attachment