Running total over Subtotals (multiple dimensionalities)

[#1]

Hi guys,

I am having some trouble getting a straight table working and the issue seems to be a number of subtotals.

The case is this:

Dimensionality()	RowNo(TOTAL)	RowNo()	Month	Week	Primo Balance	Value In	Value out	Value2 out	Difference	Ultimo Balance
2	1	1	1	1	1000	500	200	200	100	1100
2	2	2	1	2	1100	5000	1000	2000	2000	3100
2	3	3	1	3	3100	5000	3000	900	1100	2000
1	4	4	Subtotal Month 1	Subtotal Month 1	1000	10500	4200	3100	3200	2000
2	5	1	2	4	2000	1000	500	100	400	2400

I cant get the "Primo Balance" and "Ultimo Balance" nor "Difference" working, primarily because of the mixed dimensionality(). The "Primo balance = 1000" is just an inline load that is added to the real transactions as a baseline. The real transactions are the value columns.

i have tried to solve this for the last couple of hours and here are my thoughts:

- So basically the Primo Balance should take an above(UltimoBalance), but since the ultimo balance is calculated using the PrimoBalance column this seemingly creates a loop of some sort and therefore it is not as simple as this?

- I tried using RangeSum (above(sum(Difference),0,RowNo(TOTAL))), but this doesnt work either, and it just starts over after the subtotal

I hope this makes sense to any of you - basically i want the example as above duplicated and right now row 4 and 5 are simply impossible for me to figure out, as is the "difference" but this column is not important, as i just tried using that in order to populate the Balance-columns somehow.. Might be a case of "cant see the woods for all the trees" - i hope so

THANK YOU SO MUCH!

[swuehl · Accepted solution]

This is a pivot table, not a straight table right?

And could you maybe upload some few sample records for the couple of weeks shown?

[#3]

I managed to fix (HACK!) it in the meantime.. Thx for reading and wanting to help !