Full Accumulation in Straight Table, more than one Dimension

[#1]

Hi everybody, I´m Facing the problem to get Full Accumulation in a Straight Table with 3 Dimensions, I read in a few posts  that the Full accumulation only works in a Straight Table with JUST one dimension, Does any body found a Solution for this BIG ISSUE????

Thank you Guys!!

[swuehl · Accepted solution]

Try something like

=Rangesum(above(total Sum(Value),0,rowno(total)))

where sum(Value) is your expression you want to accumulate (i.e. replace the expression with the one you are using).

[#3]

Thank you Stefan, This is the first time I see the solution for this problem, You are really Goog.

Thank you Again!!

[#4]

Stefan one last question, How could I get the "ABC VTA" Column according to my criterias??? I mean, How could I get the table on left side with 3 dimensions??

I attached the App, please be patient, I takes a few minutes.

I would be really thankfull on this problem.

Thank you again Stefan.

[swuehl]

I added the expression, see attached.

Hope this helps (and in the future, please try to upload a little smaller examples, I think we will crash the Community server one day...),

Stefan

[brooksc57]

this worked for accumulation, but it freezes sorting...I'm looking but cannot yet determine why...any idea?