Full Accumulation

[#1]

Hi,

Is there a way to reverse the order of full accumulation?

Example:  Instead of the numbers increasing while scrolling down a table column, they increase while scrolling up.

[hic · Accepted solution]

Yes, but it is a little tricky...

First, do not use the radio button. Define it in the Expression instead.

If your expression is "RangeSum(below(Acc), Sum(x))" and you label the expression "Acc", then you will have it. Well, given that your field that you want to sum is called "x"...

HIC

[CELAMBARASAN]

Hi,

     Uncheck the Full Accumulation option.instead of going with the option you need to do this in expression.

     Use Expression as RangeSum(Below([This Expression label]),Sum(Sales))

Celambarasan

[jagan]

Hi,

Uncheck the Full Accumulation option, and use this expression

Sales = RangeSum(below([Sales]), Sum(FieldName))

Where Sales is your expression name.

Regards,

Jagan.

[#5]

Thanks for this.  Has anyone been able to overcome issues with this RangeSum calculation changing the line values when multiple dimensions are showing?

Thanks,

DJ