Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
use above instead of before
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