Odd behaviour with rangesum(before(sum function in pivot chart.
Having difficulties with this formula, no matter how simple I make it. Basically I'm dealing with financial data, where a field needs to represent a running sum (aggregated to the field value to the left of it, for the previous fiscal period).
When I isolate just a single row of data, the aggregated sums are represented correctly.
But when I have multiple rows (ie. separate balance sheet items), the formula doesn't consistently add to the previous - before - value, but seems to sometimes reset along the way.
Simple example that I'm using that shows this issue: =rangesum(before(sum(Budget),0,ColumnNo()))
Anyone run into a similar issue? I must be doing something wrong here.