Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
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?
I managed to fix (HACK!) it in the meantime.. Thx for reading and wanting to help !