Rangesum - Running Balance by Dimension

[#1]

I have looked at running total examples and am still lost on how to do.

We are evaluating Inventory balances by product by warehouse.

We want running totals for each change in product.

We have a record call TranType that gives us the beginning and ending balances.   We want to calc the running balance in between. 

Most of the examples i have seen use a date to control aggregation.  We dont care about date, our data is already rolling12 .

Attached is my excel using this formula for running

=IF(D6="BEG",E6,IF(D6="end","",F5+E6) )

[Anonymous]

try without aggr() as I wrote:

if(WA_12mo.WA_TranType='BEG',
sum(WA_12mo.TotalCost),
if(WA_12mo.WA_TranType<>'END',
RangeSum(
sum(WA_12mo.TotalCost),
Above(TOTAL  RunBal) //recursive...
           )
)
)

[#3]

Gah - missed that - Looks like it is working.

[Anonymous]

... I suggest, if you have further questions start a new threat, because it becomes confusing...