Running totals in two dimensional table

[Anonymous]

Colleagues, i just posted discussion about calculation columnNo in two dimensional table:

Calculate columnNo with two horizontal dims

and realized that when we use Total statement in ColumnNo(), it doesn't calculate running totals by each column.

Can anyone help to solve this thing?

Formula used in expression:

rangesum(before(sum(Sales),1,ColumnNo(total)-1))

[stabben23 · Accepted solution]

aggr(rangesum(above( sum(Sales),0,rowno(total))),Date)

[avkeep01]

Hi Staffan,

I came to the same conlusion. I've got the app attached.

AGGR(RANGESUM(ABOVE(SUM(Sales),0,ROWNO(TOTAL))),Date)

[Anonymous]

Thanks,  colleagues!!!