Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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).
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).
Thank you Stefan, This is the first time I see the solution for this problem, You are really Goog.
Thank you Again!!
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.
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
this worked for accumulation, but it freezes sorting...I'm looking but cannot yet determine why...any idea?