5 Replies Latest reply: Oct 27, 2014 12:08 PM by Gordon Cochrum

# Full Accumulation in Straight Table, more than one Dimension

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!!

• ###### Full Accumulation in Straight Table, more than one Dimension

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).

• ###### Full Accumulation in Straight Table, more than one Dimension

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

Thank you Again!!

• ###### Re: Full Accumulation in Straight Table, more than one Dimension

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.

• ###### Re: Full Accumulation in Straight Table, more than one Dimension

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

• ###### Re: Full Accumulation in Straight Table, more than one Dimension

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